Remote SQL Server 2000 backup

[PeakPerformance]

Hallo,
I have a problem with backing up a SQL Server 2000. The SQL Server is physical placed in another office and i want to make a remote backup. My problem is that i do not have access to the databases. I can see in the remote selection list that there is a SQL Server. When i mark the SQL Server i won´t show ana availible databases. I had already installed the new license on my Backup Exec 9.1 and the remote agent. I can see the local databases on the media server but not on the remote server.

Does anyone have a solution to this problem?

/Miko

 

[SQLBill]

First, the remote agent has to be installed on the REMOTE system (in this case the SQL Server). Also you say you installed the new license - what new license? The Agent for SQL Server license?

Second, to use Backup Exec to backup a SQL Server database, you must have access the database. This means the login that Backup Exec uses must be a domain account and be an account in SQL Server with backup permission.

Personnally, there is only one reason I would use third-party software to backup SQL Server. That's if I absoulutely could not do SQL Server backups from SQL Server itself. I currently backup SQL Server to disk and then use Backup Exec to copy that backup file from disk to tape. If I had to go straight to tape, I would use the SQL Server backup commands to go to tape.

-SQLBill

Posting advice: FAQ481-4875

 

[stevet3]

Bill is on the right track ...its just a permissions issue at this point. You need to gain access to the database to create a user to attach to it or a workaround would be Bills solution. Use SQL to dump the flat files out them back them up remotely. What kind of connection would you be running to get to the remote office?

 

[PeakPerformance]

Hallo SQLBill and stevet3
Thanks for your answers.
The new license that i installed was the SQL Server Agent on the Backup Exec server.

I try to create an account with the right permissions.

/Miko