SQLDBPool Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.
SQLDBPool Forum

SQL Server, MySQL DBA and Developer forum


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

2 posters

SQLDBPool Forum :: SQL Server Troubleshooting :: SQL Issues

Go down

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

Post  djshah 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

Back to top Go down

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

Post  Admin 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

https://sqldbpool.board-directory.net

Back to top Go down

Back to top

SQLDBPool Forum :: SQL Server Troubleshooting :: SQL Issues

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