p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Server 2000 (http://p2p.wrox.com/forumdisplay.php?f=20)
-   -   Move SQL DB from one sql to another sql server (http://p2p.wrox.com/showthread.php?t=24393)

Israr January 24th, 2005 06:46 AM

Move SQL DB from one sql to another sql server
 
Hi
  I want to transfer The Sql database from one sql server to another sql server along with data

Please Help


madhukp January 24th, 2005 07:06 AM

Is there any version difference between these servers ?

Are both servers accessible to you ? (This means, you should have access to the enterprise manager of both servers)

If answer to forst one is no and answer to second one is yes, then

1) you can take backup of the full database from one server through Enterprise mgr.

2) copy the .bak file to second server

3) restore through enterprise mgr of second server.

jemacc January 24th, 2005 07:30 AM

In addition to madhukp suggestions, you should also moved your user accounts and security, dts. etc. since you will have a different master database on your new server the accounts will not be mapped to the correct logins (sids)

See SQL Server Books Online to get more information about the sp_change_users_login stored procedure.

http://support.microsoft.com/kb/246133

Jaime E. Maccou

Vadivel January 24th, 2005 02:13 PM

Check out my article on detaching/attaching a database :: http://www.sswug.org/see/17226

If at all you don't have access to that article, google for sp_attach_db and sp_detach_db.

For your reference: http://databasejournal.com/features/...le.php/2224361

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com


All times are GMT -4. The time now is 04:54 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.