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)
 C Drive becoming too small Can I...

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-12-22 : 08:04:48
Jenni writes "I have 18 prduction sql databases on my C drive and one is very large and space is starting to become an issue --Can I move just the one large database to the newly installed D drive most of these databases are used with our intranet (asp pages inserting and retriving data for reports) if I can what steps do I take to set up sql server on d drive and have existing asp pages point to it. Using SQL 2000 SP2 Windows NT.

Thank You, Jenni"

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2003-12-22 : 08:20:19
Jenni,steps in order to move sql server databases are well described in a Microsoft Knowledge base article:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q224071
Kind regards.

Franco
Go to Top of Page
   

- Advertisement -