Hey everyone
I have a question for you, I am creating a database as part of the application that I am currently working one. When I create the database the .mdf and .log files go to the Sql directory however the .backup.dat file goes in my application folder. Is there anyway to disable this or have those files be elsewhere programatically.
Thanks
Kenzie
Using the BACKUP statement, you may specifically direct a backup file location.
See Books Online, Topic: BACKUP
You would issue a command similar to this:
BACKUP DATABASE MyDatabase TO DISK = 'D:\MyDataBackups\MyDatabase.bak'
No comments:
Post a Comment