1
kudos
spam Kudos Remove

Move a database from one server to another server in SQL Server 2008
published 868 days, 1 hour, 1 minute ago posted by sasa 877 days, 20 hours, 3 minutes ago
Tuesday, September 22, 2009 1:31:52 PM GMT Saturday, September 12, 2009 6:30:14 PM GMT
Move a database from one server to another server in SQL Server 2008

Move a database from one server to another server in SQL Server 2008 There are many ways to move/copy a database from one server to another server using SQL Server Tools.

i) Detach the database from the old server and attach it in the new server. This is purely offline operation and it moves the database instead of copying it.

Refer http://msdn.microsoft.com/en-us/library/ms190209.aspx : how to use attach/detach database in SQL Server Management Studio(SSMS)

ii) Back up the database in the old...

category: Management | clicked: 2 | | source: blogs.msdn.com | show counter code
tags: backup/restore, CDW, copy database, move database

No comments yet, be the first one to post comment.

To post your comment please login or signup