KellyKeeton dot Com v3.0 reverse engineering life


backup SQL database to file nightly

I dont know why this was so hard to find but since it was I bloged it…

to backup a SQL database to a file each night so that my backup software can thenback up that file to disk/tape i want a script that would backup database to diskand overwrite the old. database maintnence jobs are supposed to do this if you saydelete file older then X days however my database maintnence jobs are failing withdumb errors i dont care to fix. so here is a script job you can run to do just that.

BACKUP DATABASE %databasename% TO DISK = "%locationto backup.bak%"

Filed under: Microsoft Leave a comment
Comments (0) Trackbacks (0)

No comments yet.

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

No trackbacks yet.