SQL server Database Backup

[19902003]

Hi,

What is the best practice to backup the SQL database? I have been trying to backup one of my database and I have set the scheduled and point the backup location, but when I go back Backup again, it still shows the old settings? Can you please let me know what is the best method to backup the DB?

Many thanks,
Steve

 

[AtomicWedgie]

Hi,

maybe you will be more succesfull with your question when posting in the Setup and Administration forum?

Regards,

AW

 

[SQLBill]

I created 'dump devices' (sp_addumpdevice) and then created jobs that use the BACKUP command to backup to my dump devices.

I haven't had any problem, maybe you could provide more detail about what you did and what is happening.

-SQLBill

Posting advice: FAQ481-4875

 

[mrdenny]

When you right click on a database and select backup it doesn't pull the settings that you selected the last time you backed the database up.

To find backups that you've scheduled you'd need to look at the jobs in the SQL Agent.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com