SQL Server - Can we backup database with batch file ?

Asked By Patrick

01-Mar-10 04:42 AM

There is a request to create a batch file to backup a database in SQL
Server 2005 (In addition to database backup in maintenance plan).

Besides, in database maintenance plan, we have set up a clean up task to
clear database backup older than 1 week.  If we would like to keep the
manual (batch file) backup, does it mean that the batch SQL Server
database backup file should be located in a different place ?

Thanks

01-Mar-10 05:01 AM

Patrick
Why with batch? If you want to copy/keep  your backup , take a look into
MIRROR clause along with BACKUP command

I would prefer to keep a copy of backup file locally and  on the remote
machine as well

01-Mar-10 04:00 PM

Dear Uri,

They would like to take a database backup at any time they prefer.
Besides, they would like to take the backup without informing IT (that
my supervisor has already agreed).

Thanks

01-Mar-10 05:05 PM

If someone outside of IT will be executing it and you are willing to accept
the performance impact and security is less of an issue, I would write a
procedure and look into a variety of ways of securing it.

As to where the backup writes to, I would defiantly keep that separate from
regular backups.

02-Mar-10 02:43 AM

Patrick
Simple creating a job  that BACKUP command ..

02-Mar-10 03:49 AM

Dear Jay and Uri,

Thanks both of your for your advice.

Patrick

02-Mar-10 03:50 AM

Dear Jay and Uri,

Thanks both of your for your advice.

Patrick