August 14, 2008 at 6:23 am
hi.
i want automatically backup for my database in week days. and how to create backup devices and how to backup yesterday backup.
August 14, 2008 at 9:21 am
This will get you started, but I recommend reading about backups and maintenance plans in BooksOnLine.
Create a backup device in SQL Server Management Studio by right-clicking Server Objects in Object Explorer, selecting "New", then "Backup Device...".
Create a maintenance plan to backup databases by expanding Management in Object Explorer, right-clicking Maintenance Plans, and selecting "New Maintenance Plan..." or "Maintenance Plan Wizard".
Greg
August 15, 2008 at 4:48 am
use the SP_Addumpdevice stored proc, syntax is as follows
'type', 'device name', 'drive:\path\file'
type is either disk or tape
device name is the logical name you want to use
drive:\path\file should be self explanatory
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply