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
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Change DATA disk to bigger

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-06-01 : 07:35:02
Martin writes "I store the data at the dedicate HDD (D drive). Now I need to change it to bigger one. How can I make it at the simplest way? Is possible stop server, copy data structure to new disk with ACL, change drive letter and start server?

W2k Server SP4, MS SQL2000 Standart SP3

Thank's"

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-06-01 : 08:25:59
Doesn't exactly work that way. See this article for moving databases. Every DBA should have it in their favorites.

http://support.microsoft.com/default.aspx?scid=kb;en-us;224071&Product=sql

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -