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 |
|
missMac
Posting Yak Master
124 Posts |
 Posted - 2009-08-17 : 04:00:52
|
| Hello,when we installed our db, the files were set to c drive which apparently hasnt got much space.1. How do we change it to d:\ drive2. or if we were to backup and restore, how do we restore it to d:\ drive, bearing in mind that d drive hasnt gotc:\Program Files\Microsoft SQL Server\MSSQL10.mydatabase\MSSQL\DATA\db.mdfor do i create the folder ?thanksmm |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-08-17 : 05:34:33
|
Create the wanted folder on drive d: and restore to it.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-08-17 : 05:55:41
|
create the required path as webfred as suggested.And when you restore your database, specify the data and log path in the restore command. If you are using SSMS, you can also do that via the dialog box.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
Changing the data files for MSSQL