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"
You may change in your package at the time of restoring Database. Regards, Virendra Yaduvanshi
quote: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
Posted - 10/01/2012 : 14:40:37
