can I use Attach/Detach database method to move the system DBs in SQL Server 2008?

View previous topic View next topic Go down

can I use Attach/Detach database method to move the system DBs in SQL Server 2008?

Post  djshah on Mon Nov 14, 2011 2:07 pm

We are planning move the system databases on the different drives? Can I use the simply attach detach to move the Dbs?

djshah

Posts : 1
Join date : 2011-11-14

View user profile

Back to top Go down

Re: can I use Attach/Detach database method to move the system DBs in SQL Server 2008?

Post  Admin on Mon Nov 14, 2011 2:09 pm

No. Please use ALTER Database to move the system databases except master. Master you have to move it by editing the startup parameters.

Admin
Admin

Posts : 8
Join date : 2011-11-14

View user profile http://sqldbpool.forumotions.in

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum