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.
| Author |
Topic |
|
yongsan
Starting Member
1 Post |
 Posted - 2005-09-02 : 00:52:38
|
| Hi,Very new to MS SQL and I would like to know how can I migrate it to another partition?I have MS SQL 2000 installed on Windows 2003 Standard Edtion in C:\mssql. I would like to migrate all the database as well as the new ones which I will be creating in the future to D:\mssql\ which has more diskspace.Is there anyway to change the path?Thnks for the help! :> |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-09-02 : 08:40:17
|
| You can use ALTER DATABASE to move files around.or you could BACKUP all of your databases, DROP them and then do a RESTORE WITH MOVE.====================================================Regards,Sean Roussy"pimpin ain't easy, but someone has to do it" -- Pimpin Whitefolks(?) |
 |
|
|
DMcCallie
Yak Posting Veteran
62 Posts |
Posted - 2005-09-02 : 10:31:46
|
| Sure it's easy as I just did this last week:http://support.microsoft.com/default.aspx?scid=kb;en-us;224071 |
|
|
|
|
|
|
How to migrate MSSQL to another partition?