General discussion

Locked

Arcserver Error

By lgod ·
I installed Arcserver backup software on company NT Server. When I check backup job every morning, it does not complete. It gives error massage " Error 3404 unable to open file." And it show me the file name. Those files are database files on MS SQL.
How can I solve this problem???

This conversation is currently closed to new comments.

12 total posts (Page 1 of 2)   01 | 02   Next
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Arcserver Error

by SyscoKid In reply to 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.

Collapse -

Arcserver Error

by lgod In reply to Arcserver Error

The question was auto-closed by TechRepublic

Collapse -

Arcserver Error

by tigre_269 In reply to Arcserver Error

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.

Collapse -

Arcserver Error

by lgod In reply to Arcserver Error

The question was auto-closed by TechRepublic

Collapse -

Arcserver Error

by mark_lt In reply to Arcserver Error

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

Collapse -

Arcserver Error

by lgod In reply to Arcserver Error

The question was auto-closed by TechRepublic

Collapse -

Arcserver Error

by Tejota In reply to Arcserver Error

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:

Collapse -

Arcserver Error

by lgod In reply to Arcserver Error

The question was auto-closed by TechRepublic

Collapse -

Arcserver Error

by Tejota In reply to Arcserver Error

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:

Collapse -

Arcserver Error

by Tejota In reply to Arcserver Error

You can specify these start and stop batch files in your backup software. Remember, only by stopping the DB will you get good backups of it. Hope this helped.

Back to Windows Forum
12 total posts (Page 1 of 2)   01 | 02   Next

Related Discussions

Related Forums