Arcserver Error

You'll get that if the file is in use, or if Backup doesn't have rights to that directory. I get them every night, usually to do with temp files, and ignore them.

There may be some processes running that you need to stop before starting Arcserve in order to back up tose databases.

If you need to backup general(user files, word, excel etc.) open files, look into an open file agent. We used St. Bernards Open File Manager. I had some problems with it, but it worked well for the most part. In regards to SQL. You need to run abackup within SQL server of the database to a seperate file, then backup that file. The DBA's setup SQL so that it would backup the databae about three hours before the ARCserve nightly backups kicked off. That is the only way to backup/restore the SQL database. Good luck.

in Arcserve options, you can list batch files to run before and after the backup.

Create a script to stop the sql service "net stop etc" and for the post backup, create a script that restarts the sql services, "net start etc"

that will sort you out

The only way to get a good backup of your SQL database is to shut it down at night, run the backup, then restart it. Obviously, you can't stay at work 24/7 for this, so you need to install the NT Resource kit that gives you the utility (AT Scheduler) to all this as a scheduled task....similar to scheduling a scandisk of your 98 pc with the task scheduler. After you've installed the resource kit, follow these instructions:

To Stop or Start SQL Server Through the AT Scheduler at Specific Times, to

Perform Backups of the SQL Server Device Files
----------------------------------------------

1. Create two text files using a text editor such as Notepad. You may want to
name the files Users\Default\Stop.bat and Users\Default\Start.bat.

In SQL Server version 4.2x, the services are SQLSERVER and SQLMONITOR. In SQL
Server version 6.0 and 6.5, the services are MSSQLSERVER, SQLEXECUTIVE, and
optionally MSDTC. In SQL Server version 7.0, the services are MSSQLServer, SQLServerAgent, and optionally MSDTC.

Add the following lines to the Stop.bat file:

net stop mssqlserver
net stop sqlexecutive

Add the following lines to the Start.bat file:

net start mssqlserver
net start sqlexecutive

2. Schedule your Stop.bat file to run. NOTE: It may be easier if you can combine
the Stop.bat, tape backup, and Start.bat all in one batch file.

For example, if you want to stop the SQL Server services at 8:00 P.M. every
night, type the following:

AT 20:00 /every:M,T,W,TH,F,S,SU "c:\users\default\stop.bat"

3. Once SQL Server is stopped, you can use whatever tape backup utility you want
to make backups of the SQL Server device files.

4. Once the device files have been copied to tape, you should restart SQL
Server. For example, if you want to start the SQL Server services at 11:00
P.M. every night, type the following:

The only way to get a good backup of your SQL database is to shut it down at night, run the backup, then restart it. Obviously, you can't stay at work 24/7 for this, so you need to install the NT Resource kit that gives you the utility (AT Scheduler) to all this as a scheduled task....similar to scheduling a scandisk of your 98 pc with the task scheduler. After you've installed the resource kit, follow these instructions:

To Stop or Start SQL Server Through the AT Scheduler at Specific Times, to

Perform Backups of the SQL Server Device Files
----------------------------------------------

1. Create two text files using a text editor such as Notepad. You may want to
name the files Users\Default\Stop.bat and Users\Default\Start.bat.

In SQL Server version 4.2x, the services are SQLSERVER and SQLMONITOR. In SQL
Server version 6.0 and 6.5, the services are MSSQLSERVER, SQLEXECUTIVE, and
optionally MSDTC. In SQL Server version 7.0, the services are MSSQLServer, SQLServerAgent, and optionally MSDTC.

Add the following lines to the Stop.bat file:

net stop mssqlserver
net stop sqlexecutive

Add the following lines to the Start.bat file:

net start mssqlserver
net start sqlexecutive

2. Schedule your Stop.bat file to run. NOTE: It may be easier if you can combine
the Stop.bat, tape backup, and Start.bat all in one batch file.

For example, if you want to stop the SQL Server services at 8:00 P.M. every
night, type the following:

AT 20:00 /every:M,T,W,TH,F,S,SU "c:\users\default\stop.bat"

3. Once SQL Server is stopped, you can use whatever tape backup utility you want
to make backups of the SQL Server device files.

4. Once the device files have been copied to tape, you should restart SQL
Server. For example, if you want to start the SQL Server services at 11:00
P.M. every night, type the following:

This question was auto closed due to inactivity