RMS 1.2 Database Backup

Posted by Gerd on August 28, 2005, 6:58 am

Please log in for more thread options

I am looking for a small batch files that backs up my POS database on a
daily basis where the backup file name is the system date and time.

I found a batch file backup with a fixed file name on MS Customer Source but
would rather want to keep daily copies.

Posted by Antonio Mazzeo on August 29, 2005, 10:07 am

Please log in for more thread options

>I am looking for a small batch files that backs up my POS database on a

>daily basis where the backup file name is the system date and time.

> I found a batch file backup with a fixed file name on MS Customer Source

> but would rather want to keep daily copies.

BACKUP DTABASE yourdbname TO DISK = 'yourpathbackupdb_' +
str(year(getdate())) + str(month(getdate())) + str(day(getdate())) +
str(datepart(hh,getdate()))+str(mi(getdate()))+str(datepart(ss,getdate()))
'.bck'

Posted by Gerd on August 29, 2005, 4:00 am

Please log in for more thread options

Thanks Antonio, that's exactly what I was looking for.

>>I am looking for a small batch files that backs up my POS database on a

>>daily basis where the backup file name is the system date and time.

>> I found a batch file backup with a fixed file name on MS Customer Source

>> but would rather want to keep daily copies.

> BACKUP DTABASE yourdbname TO DISK = 'yourpathbackupdb_' +

> str(year(getdate())) + str(month(getdate())) + str(day(getdate())) +

> str(datepart(hh,getdate()))+str(mi(getdate()))+str(datepart(ss,getdate()))

> '.bck'

Posted by Gerd on August 29, 2005, 5:00 am

Please log in for more thread options

Antonio,

I just tried to run the following db_backup.cmd but get an error on the +
sign. Here is the exact syntax of the command with the error message:

C:Program FilesMicrosoft Retail Management System>OSQL -U UserName -P
password -S TCS50
-Q "BACKUP DATABASE main TO DISK = 'c:Program FilesMicrosoft Retail
Management SystemBackupBackup-' + str(year(getdate())) +
str(month(getdate())) + str(day(getdate())) '.bck' WITH FORMAT, STATS"
Msg 170, Level 15, State 1, Server TCS50, Line 1
Line 1: Incorrect syntax near '+'.

>>I am looking for a small batch files that backs up my POS database on a

>>daily basis where the backup file name is the system date and time.

>> I found a batch file backup with a fixed file name on MS Customer Source

>> but would rather want to keep daily copies.

> BACKUP DTABASE yourdbname TO DISK = 'yourpathbackupdb_' +

> str(year(getdate())) + str(month(getdate())) + str(day(getdate())) +

> str(datepart(hh,getdate()))+str(mi(getdate()))+str(datepart(ss,getdate()))

> '.bck'

Posted by Antonio Mazzeo on August 29, 2005, 3:30 pm

Please log in for more thread options

> Antonio,

> I just tried to run the following db_backup.cmd but get an error on the +

> sign. Here is the exact syntax of the command with the error message:

> C:Program FilesMicrosoft Retail Management System>OSQL -U UserName -P

> password -S TCS50

> -Q "BACKUP DATABASE main TO DISK = 'c:Program FilesMicrosoft Retail

> Management SystemBackupBackup-' + str(year(getdate())) +

> str(month(getdate())) + str(day(getdate())) '.bck' WITH FORMAT, STATS"

> Msg 170, Level 15, State 1, Server TCS50, Line 1

> Line 1: Incorrect syntax near '+'.

DECLARE @fullpath nvarchar(255)

set @fullpath = 'c:Program FilesMicrosoft Retail
Management SystemBackupBackup-' + str(year(getdate())) +
str(month(getdate())) + str(day(getdate())) + '.bck'

BACKUP DATABASE main TO DISK = @fullpath WITH FORMAT, STATS

sorry for my error
antonio