Thursday, March 22, 2012

Do i alsocopy sys dbs when i copy a db to a new disk with 'Att & D

Hi all
I need to copy a user database from disk E to disk G using the 'attach and
detach' and then take that disk to another server where i will attach the
database. Do i also have to copy the systems databases (Master, MSDB, Model)?
How do i also keep the logins and security features that were on the
databases previously? I cant use 'import and export data' as the other
machine is not on the domain/network.
Thank you in advance
You don't have to.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"MittyKom" <MittyKom@.discussions.microsoft.com> wrote in message
news:E7B05938-593E-4F3C-9124-EC9957207120@.microsoft.com...
> Hi all
> I need to copy a user database from disk E to disk G using the 'attach and
> detach' and then take that disk to another server where i will attach the
> database. Do i also have to copy the systems databases (Master, MSDB,
> Model)?
> How do i also keep the logins and security features that were on the
> databases previously? I cant use 'import and export data' as the other
> machine is not on the domain/network.
> Thank you in advance

No comments:

Post a Comment