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 |
|
jayram
Starting Member
47 Posts |
 Posted - 2012-10-01 : 14:40:37
|
| hi,i have a SQL job that runs off a DTS package which creates a backup MDF file and attaches it to the server as a database everyday with a unique name like DATABASE_20120928, DATABASE_20120929 etc. They currently run on my C drive which is were all mdf and ldf are stored for all the databases.is it possible to change the default data and log directory to another drive for this job alone."Enterprise Manager - right click on the Server - property - Database settings - Default Data / Log Direcotry" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
v_yaduvanshi
Starting Member
11 Posts |
Posted - 2012-10-12 : 08:26:40
|
You may change in your package at the time of restoring Database.Regards,Virendra Yaduvanshiquote:
Originally posted by jayram
hi,i have a SQL job that runs off a DTS package which creates a backup MDF file and attaches it to the server as a database everyday with a unique name like DATABASE_20120928, DATABASE_20120929 etc. They currently run on my C drive which is were all mdf and ldf are stored for all the databases.is it possible to change the default data and log directory to another drive for this job alone."Enterprise Manager - right click on the Server - property - Database settings - Default Data / Log Direcotry"
|
 |
|
|
|
|
|
How to change default path for database creation