use local disk for backup

[holdahl]

I'm trying to use a local disk for backup of my databases in sql server 2005.

Is there a way to define this disk in management studio or do you have to create backup-scripts which points to this disk?

I have tried to define a backup device, but it doesn't seem to work. Also I want a separate file for each database.

Any suggestions?


sH

 

[ptheriault]

how are you trying to define your backup device.
In management studio you should select server objects then right click on backup devices and select new device. At that point you name the device and point it to the file location you want. Then you can create your backup job to use that device. In SQL 2000 you used to be able to create the device from the creation of the backup job. But now you must create the device first.

 

[ptheriault]

I create a seperate device for each database and log backup. So I have db_nameDataDump and db_nameLogDump device. I then do a night full data dump and then I init the log device and write 1/2 increm log dumps to it.

 

[holdahl]

So you do have to create a separate backup-device for each database. Thought it was possible to use a shared backup-device for all databases and just create a different .bak file for each database.


sH

 

[holdahl]

basically what I want is this:

to define a local disk:

F:\Backup\Base_copy (under this catalog put backup of data from databases)

F:\Backup\Log_copy (under this catalog put the backup of transactionlog from databases)

sH

 

[ptheriault]

you can do that but you wouldn't want to. If you are doing incremental log backups you have to init your device after your full data backup. Plus you want to keep things simple. you don't want to have to go searching through the device to find the correct backup set.

 

[holdahl]

do most of you use the maintenance plan (and the job) to do a backup or just making sql scripts which does the backup?


sH

 

[Catadmin]

I use maintenance plans at my job, but we also have Litespeed installed, which changes how things are done with backups.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"