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.
| Author |
Topic |
|
leodone
Starting Member
30 Posts |
 Posted - 2009-08-04 : 12:02:17
|
| I wanted to know if you detach a database does the security info (Logins and Server Roles) fellow the database?What I trying to do is to move databases from a old server to a new server. I want to make sure when I reattach those database that all maintance plans and security info and etc gets moved over automaticatly when I attach the databaes onto the new server without me recreating everything again. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-08-04 : 13:49:32
|
| Logins and server roles are stored in the master database, so they will not be present when you move the database to another server.What I do to ensure everything is exactly the same on the new server is I use the same exact paths on the new server, stop SQL Server on the old and new server, copy over all database files (mdfs, ldfs for all user and system databases) to the new server, and then start SQL Server on the new server. This will grab everything inside SQL Server, but the paths must be exact in order for this to work.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
|
|
|
Detach and attach a database