MRMS 2.0 - BACKUP

Do a search in the newsgroup for Backup and you will find plenty of information that has been posted previously.

Hi Try this: Create *.bat file like below

osql -U sa -P database_password -S server_name -Q "BACKUP DATABASE database_nam TO DISK = 'c:\backups\backup.bck' WITH FORMAT, STATS

Then go to windows scheduler and simply add this to be run every day, hour or like you want.

You can also play a little bit with automatic names for files using something like: .... TO DISK = 'c:\backups\DATA-%date%.bck' WITH FORMAT, STATS what should give you filename: DATA-02/12/2008.bck ofcourse windows doesn't like "/" sign in names so you can go to regional settings and change date separator from "/" to "-".

Regards Mirek Wieclawski Slowey Systems Ireland

"RK" wrote: