DBBackup Script

Jan 6, 2005

I have generated an SQL script from a job that does the complete backup of the database.
What does DISK -BkUpDB "M:Backups"? Does it just put the backup file on the M: drive?
Also, I have generated an SQL script that does the Transaction Log backup. When I compare two scripts the Add the job steps for a complete db backup and transaction log backup look identical. The only difference is DISK -BkUpDB in the DBBackup script and DISK -BkUpLog in the Transaction Log backup.
How does SQL Server knows that it has to create a db backup vs. transaction log backup?
I can't find the documentaition that would explain that.
Please help.

View 3 Replies

Dbbackup.exe To Backup MSDE Instance

Feb 16, 2007

I'm running a Scheduled Task to execute dbbackup.exe to backup a local MSDE Instance for Live Comm. Server. When I save it to the local drive it works fine but I'm trying to save the backup to a remote server. I can't seem to get it to work. The account being used has full access to the remote computer and backup folder share.

Syntax:

"C:program filesms lcs 2005serversupportdbbackup.exe" /backupfile:\servernameackupmsdebackup

but when I run the following it works fine:
"C:program filesms lcs 2005serversupportdbbackup.exe" /backupfile:c:ackupmsdebackp

Any ideas? Thanks for any help!!!

View 3 Replies

View Related