I know this might be a silly question, but I've forgotton how to back up a sql server database.
What i'd like to do is have it place all the files for the forum database in a directory on my data partition. Then when I run my backup program over that partition, it will be backed up.
Is this possible. If not, what files do you need to backup and where are they located (default install).
Setup a Job to create the backup and place them where you need them, you'll need SQL Agent running to have it run automatically.
Setup a job that executes some T-SQL similar to this
BACKUP DATABASE [database] TO DISK = N'C:\MyBackups\database.bkp' WITH INIT , NOUNLOAD , NAME = N'Datbase backup', NOSKIP , STATS = 10, NOFORMAT
If you smurf around in Enterprise Manager theres some Wizards for building this all for you as well, just can't remember the exact place off the top of my head to find them.
You could just use the maintenance job wizard too which does create a backup as well, I usually do this for my larger DB's as the maintenance steps include an integrity check of the DB before backing it up along with a few other handy things.
Topic Locked
Posted - 17 October 2004 : 02:17:16
