Automating backup in RMS

Posted by Larry Jenuwine on June 2, 2005, 9:10 am

Please log in for more thread options

Does anyone have an easy solution for automatically backing up the database
for RMS? Our clerks seem to be unable to remember to do it daily.

Thanks for any help.

Larry

Posted by root on June 2, 2005, 12:21 pm

Please log in for more thread options

Larry,

You can do a .bat file and schedule it to run in the scheduled tasks OR you
can download the SQL trial and only install the Enterprise Manager part.
Enterprise Manager will give you the GUI for MSDE and enable you to do a
scheduled maintenance plan with backup, shrink, and other tasks...

> Does anyone have an easy solution for automatically backing up the

> database

> for RMS? Our clerks seem to be unable to remember to do it daily.

> Thanks for any help.

> Larry

Posted by kskinne on June 2, 2005, 1:39 pm

Please log in for more thread options

root - what would the command line need to be in the .bat file to initiate
the backup process?

thanks,
kevin

"root" wrote:

> Larry,

> You can do a .bat file and schedule it to run in the scheduled tasks OR you

> can download the SQL trial and only install the Enterprise Manager part.

> Enterprise Manager will give you the GUI for MSDE and enable you to do a

> scheduled maintenance plan with backup, shrink, and other tasks...

> > Does anyone have an easy solution for automatically backing up the

> > database

> > for RMS? Our clerks seem to be unable to remember to do it daily.

> >

> > Thanks for any help.

> >

> > Larry

Posted by Rob on June 2, 2005, 2:48 pm

Please log in for more thread options

1.. In Notepad, paste the following text in the new batch file:

osql -U sa -P -S server name -Q "BACKUP DATABASE database name TO DISK =
'e:backupback1.bck'"a.. If you have a password for the system
administrator user, you must enter the password after the -P parameter. For
example, insert -P password.
b.. Replace server name with the name of your server. You can see the
name of your server in the SQL Server Service Manager.
c.. Replace database name with the actual name of your Store Operations
database or Headquarters database.
d.. Replace e:backupback1.bck with the actual path of the drive and
the directory where you want to save the backup and the actual name that you
want for the backup file.
2.. Save the file.
3.. Click Start, point to All Programs, point to Accessories, point to
System Tools, and then click Scheduled Tasks.

Use Task Scheduler to run your batch file from the server. See Windows
Help for more information about how to set up and how to run Task Scheduler.
Important Every time that you use Task Scheduler to run your batch file, the
backup file name that the batch file generates is the same file name that
you entered for the path and file name when you created the batch file.
Therefore, if you want to maintain a series of backup files, use one of the
following methods before or after you run the backup:

a.. Move the backup file to another location.
b.. Rename the backup file.
Otherwise, the backup file will be appended every time that you use Task
Scheduler to run the batch file. This may make the backup file unusable.

> root - what would the command line need to be in the .bat file to initiate

> the backup process?

> thanks,

> kevin

> "root" wrote:

>> Larry,

>> You can do a .bat file and schedule it to run in the scheduled tasks OR

>> you

>> can download the SQL trial and only install the Enterprise Manager part.

>> Enterprise Manager will give you the GUI for MSDE and enable you to do a

>> scheduled maintenance plan with backup, shrink, and other tasks...

>> message

>> > Does anyone have an easy solution for automatically backing up the

>> > database

>> > for RMS? Our clerks seem to be unable to remember to do it daily.

>> >

>> > Thanks for any help.

>> >

>> > Larry

Posted by kskinne on June 2, 2005, 2:23 pm

Please log in for more thread options

perfect - thank you rob

"Rob" wrote:

> 1.. In Notepad, paste the following text in the new batch file:

> osql -U sa -P -S server name -Q "BACKUP DATABASE database name TO DISK =

> 'e:backupback1.bck'"a.. If you have a password for the system

> administrator user, you must enter the password after the -P parameter. For

> example, insert -P password.

> b.. Replace server name with the name of your server. You can see the

> name of your server in the SQL Server Service Manager.

> c.. Replace database name with the actual name of your Store Operations

> database or Headquarters database.

> d.. Replace e:backupback1.bck with the actual path of the drive and

> the directory where you want to save the backup and the actual name that you

> want for the backup file.

> 2.. Save the file.

> 3.. Click Start, point to All Programs, point to Accessories, point to

> System Tools, and then click Scheduled Tasks.

> Use Task Scheduler to run your batch file from the server. See Windows

> Help for more information about how to set up and how to run Task Scheduler.

> Important Every time that you use Task Scheduler to run your batch file, the

> backup file name that the batch file generates is the same file name that

> you entered for the path and file name when you created the batch file.

> Therefore, if you want to maintain a series of backup files, use one of the

> following methods before or after you run the backup:

> a.. Move the backup file to another location.

> b.. Rename the backup file.

> Otherwise, the backup file will be appended every time that you use Task

> Scheduler to run the batch file. This may make the backup file unusable.

> > root - what would the command line need to be in the .bat file to initiate

> > the backup process?

> >

> > thanks,

> > kevin

> >

> > "root" wrote:

> >

> >> Larry,

> >>

> >> You can do a .bat file and schedule it to run in the scheduled tasks OR

> >> you

> >> can download the SQL trial and only install the Enterprise Manager part.

> >> Enterprise Manager will give you the GUI for MSDE and enable you to do a

> >> scheduled maintenance plan with backup, shrink, and other tasks...

> >>

> >> message

> >> > Does anyone have an easy solution for automatically backing up the

> >> > database

> >> > for RMS? Our clerks seem to be unable to remember to do it daily.

> >> >

> >> > Thanks for any help.

> >> >

> >> > Larry

> >>