What is the best document for restoring databases from one SQL 2000 server to a new SQL 2000 server?
What do you mean by document?
Refer to Books Online (within the SQL Server program group). It will =
tell you how to use the Transact-SQL commands BACKUP and RESTORE. =20
You might also find these KB articles helpful:
INF: Disaster Recovery Articles for Microsoft SQL Server
http://www.support.microsoft.com/?id=3D307775
INF: Moving SQL Server databases to a new location with Detach/Attach
http://www.support.microsoft.com/?id=3D224071
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://www.support.microsoft.com/?id=3D314546
INF: Using the WITH MOVE Option with the RESTORE Statement
http://support.microsoft.com/?id=3D221465
PRB: User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=3D168001
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=3D246133
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is =
Incomplete
http://www.support.microsoft.com/?id=3D274188
How to Resolve Permission Issues When a Database Is Moved Between SQL =
Servers
http://www.support.microsoft.com/?id=3D240872
SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases =
When Database Is Moved
http://www.support.microsoft.com/?id=3D298897
--=20
Keith
"new2sql" <anonymous@.discussions.microsoft.com> wrote in message =
news:E22BCD34-B235-420E-848E-9C2A63576020@.microsoft.com...
> What is the best document for restoring databases from one SQL 2000 =
server to a new SQL 2000 server?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment