Auto Backup

Posted by Steve on October 22, 2008, 1:08 am

Please log in for more thread options

Does anyone have a .bat script for Microsoft RMS 2.0 for auto backup? I've
tried the following, but did not have any luck..

osql -U sa -P password -S servername -Q "BACKUP DATABASE
databasename TO DISK = 'c:database.bck'WITH FORMAT, STATS"

Any help will be greatly appreciated.

Posted by Michael on October 22, 2008, 3:53 am

Please log in for more thread options

What errors are you getting?

Add this to the end so it logs the operation to a text file

>> "c:BackUp-Log.txt"

Your command line should look like this

osql -U sa -P password -S servername -Q "BACKUP DATABASE databasename TO
DISK = 'c:database.bck' WITH FORMAT, STATS" >> "c:BackUp-Log.txt"

Check what the BackUp-Log.txt file says after trying and it might give a
clue as to what the problem is

--
Disclaimer:

Always test any queries that modify data on a test database prior to running
on your live data to ensure the desired results.

Always back-up prior to running any SQL delete queries on your live data.

--

Regards
Michael
(Brisbane, Australia)

> Does anyone have a .bat script for Microsoft RMS 2.0 for auto backup? I've

> tried the following, but did not have any luck..

> osql -U sa -P password -S servername -Q "BACKUP DATABASE

> databasename TO DISK = 'c:database.bck'WITH FORMAT, STATS"

> Any help will be greatly appreciated.

Posted by Michael on October 22, 2008, 3:55 am

Please log in for more thread options

Sorry the log file should look like this

10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.
Processed 154608 pages for database 'DatabaseName', file 'QSDB_Data' on file
1.
100 percent processed.
Processed 2 pages for database 'DatabaseName', file 'QSDB_Log' on file 1.
BACKUP DATABASE successfully processed 154610 pages in 88.209 seconds
(14.358
MB/sec).

--
Disclaimer:

Always test any queries that modify data on a test database prior to running
on your live data to ensure the desired results.

Always back-up prior to running any SQL delete queries on your live data.

--

Regards
Michael
(Brisbane, Australia)

> Does anyone have a .bat script for Microsoft RMS 2.0 for auto backup? I've

> tried the following, but did not have any luck..

> osql -U sa -P password -S servername -Q "BACKUP DATABASE

> databasename TO DISK = 'c:database.bck'WITH FORMAT, STATS"

> Any help will be greatly appreciated.

Posted by Steve on October 22, 2008, 11:55 am

Please log in for more thread options

Hi Michael,

Thank you for your response. For some very odd reason, it does not create
the backup file or the txt file.

I am replacing the 'password' with the actual database password. Also, I am
changing the servername with the computer name which is running the database
and the database name is 'database'.

When I run the .bat file, it opens up the command prompt (cmd) and quickly
closes the window.

"Michael" wrote:

> Sorry the log file should look like this

> 10 percent processed.

> 20 percent processed.

> 30 percent processed.

> 40 percent processed.

> 50 percent processed.

> 60 percent processed.

> 70 percent processed.

> 80 percent processed.

> 90 percent processed.

> Processed 154608 pages for database 'DatabaseName', file 'QSDB_Data' on file

> 1.

> 100 percent processed.

> Processed 2 pages for database 'DatabaseName', file 'QSDB_Log' on file 1.

> BACKUP DATABASE successfully processed 154610 pages in 88.209 seconds

> (14.358

> MB/sec).

> --

> Disclaimer:

> Always test any queries that modify data on a test database prior to running

> on your live data to ensure the desired results.

> Always back-up prior to running any SQL delete queries on your live data.

> --

> Regards

> Michael

> (Brisbane, Australia)

> > Does anyone have a .bat script for Microsoft RMS 2.0 for auto backup? I've

> > tried the following, but did not have any luck..

> >

> > osql -U sa -P password -S servername -Q "BACKUP DATABASE

> > databasename TO DISK = 'c:database.bck'WITH FORMAT, STATS"

> >

> > Any help will be greatly appreciated.

Posted by Marc on October 22, 2008, 1:26 pm

Please log in for more thread options

Try running it from a command line so you can see any error message being
generated.

Marc

> Hi Michael,

> Thank you for your response. For some very odd reason, it does not create

> the backup file or the txt file.

> I am replacing the 'password' with the actual database password. Also, I

> am

> changing the servername with the computer name which is running the

> database

> and the database name is 'database'.

> When I run the .bat file, it opens up the command prompt (cmd) and quickly

> closes the window.

> "Michael" wrote:

>> Sorry the log file should look like this

>> 10 percent processed.

>> 20 percent processed.

>> 30 percent processed.

>> 40 percent processed.

>> 50 percent processed.

>> 60 percent processed.

>> 70 percent processed.

>> 80 percent processed.

>> 90 percent processed.

>> Processed 154608 pages for database 'DatabaseName', file 'QSDB_Data' on

>> file

>> 1.

>> 100 percent processed.

>> Processed 2 pages for database 'DatabaseName', file 'QSDB_Log' on file 1.

>> BACKUP DATABASE successfully processed 154610 pages in 88.209 seconds

>> (14.358

>> MB/sec).

>> --

>> Disclaimer:

>> Always test any queries that modify data on a test database prior to

>> running

>> on your live data to ensure the desired results.

>> Always back-up prior to running any SQL delete queries on your live data.

>> --

>> Regards

>> Michael

>> (Brisbane, Australia)

>> > Does anyone have a .bat script for Microsoft RMS 2.0 for auto backup?

>> > I've

>> > tried the following, but did not have any luck..

>> >

>> > osql -U sa -P password -S servername -Q "BACKUP DATABASE

>> > databasename TO DISK = 'c:database.bck'WITH FORMAT, STATS"

>> >

>> > Any help will be greatly appreciated.