ok... ive tryed doing it... i just cant get it to back up the way i wish... unless im doing it worng...
is there a way to auto back up the db and the MDF logs? and have it do it like ervy day? and save it on my C and D drive?
Thank you.
ps. im asking soo much whith MSSQL becuse theres not much "good" help sites that are free.
0
Auto Backup of DB MSSQL 2005
Started by Ace-SG1-, Sep 07 2007 09:00 PM
1 reply to this topic
#2
-
- Members
-
- 970 posts
P2L Jedi
- Gender:Male
- Location:A strange world where water falls out of the sky... for no reason.
- Interests:Graphic Design, Coding, Splinter Cell, Cats
Posted 08 September 2007 - 12:11 PM
The only way you can do this is to set-up a cron job, something common with *nix systems. I don't quite know how to do it with Windows, but I'm sure there are programs out there that will do it for you (other than making PHP do it, which would then require using a database to track itself, so you're using the database to back itself up, lol).
I'm not familiar with MSSQL, but since its SQL, it should be very similar to any tutorial you'd find for backing up a MySQL database, save for some syntax and change of functions (example, with PHP, you'd use mssql_*() functions instead of mysql_*() functions).
I'm not familiar with MSSQL, but since its SQL, it should be very similar to any tutorial you'd find for backing up a MySQL database, save for some syntax and change of functions (example, with PHP, you'd use mssql_*() functions instead of mysql_*() functions).
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users
