Copy Databases between PC's - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Copy Databases between PC's

Author

Topic

sanj
Starting Member

22 Posts

Posted - 2008-12-22 : 16:29:20

Hi,

What is the best practice to copy databases between PC's, coming from a Access background it was quite simple to copy the MDB file, but seems a bit different for SQL, should I use backup then restore? if so is there any special requirements i.e. same users, privileges etc?

Thanks

hanbingl
Aged Yak Warrior

652 Posts

Posted - 2008-12-22 : 16:46:27

online: backup and restore
offline: detach and attach

sanj
Starting Member

22 Posts

Posted - 2008-12-22 : 16:53:59

Thanks for the reply - just to confirm, I don't need to worry about any permissions of the DB?

Thanks!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-22 : 16:58:23

Permissions are contained inside the database, so when you restore it, all permissions will be present. You might have issues with logins though as those are stored in the master database.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

hanbingl
Aged Yak Warrior

652 Posts

Posted - 2008-12-22 : 17:19:37

for more info on moving database, here is the link to BOL: http://msdn.microsoft.com/en-us/library/ms189133.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources