SQL Server 2000 need to prevent logons whilst performing a backup for a side by side migration
Posted
by pigeon
on Server Fault
See other posts from Server Fault
or by pigeon
Published on 2010-03-09T01:51:45Z
Indexed on
2010/03/09
2:08 UTC
Read the original article
Hit count: 340
I'm looking for a way to prevent logons from occurring in order to take a full backup of a Database to migrate from its current SQL Server 2000 instance to a new SQL 2005 instance. A friend of mine suggested running a script which would put the DB into a rollback state. Not being a DBA my DDL is very poor and running a script that I don't understand may not be the best idea.
One option which might be easier is to simply detach and copy, to the new server.
Any suggestions would be greatly appreciated.
© Server Fault or respective owner