Can I use Remote Agent to backup databases?

[vasara]

Can I use Remote Agent to backup remote servers which contains databases (one has Oracle, one has SQL server running, one has running Lotus Notes)?

Do I need the Agents for current databases?

Is it possible to stop database services on remote server using remote Agent? (like net stop mssqlserver and so on...)

 

[SQLBill]

You need the database agent only if you want BE to 'act' like that system. In other words....I have a SQL Server 2000 database, I want to back it up....if I have the SQL Agent then my database acknowledges the BE backup as being a SQL backup. However, there is another option...if I don't buy the agent, then I need to perform the builtin backup and save the backup to a hard drive and then use BE to copy the backup file to tape. I have seen some opinions that that's the best way to do it.

As for Remote Agent, yes you will need it if you are backing up a remote datebase.

-SQLBill

 

[vasara]

Does anyone know how to stop Oracle and Notes services for Backup?

Does anyone have an example from the script how to stop services and copy databases to hard drive?

I'm using Windows NT 4.0 server op

thnx

 

[saraski]

First search for all batch folders in the root of program files. See if they stop the services with a batch file (*.bat) then use that or the "Net Stop" command.

 

[Qdog]

You are restricted to a flat-file backup of your SQL database if you don't have the SQL Server agent installed. So you have to stop the SQL Server services and if it is on a Win2K box, backup the System State, SQL Server installation folder (%systemrootdrive%\Program Files\Microsoft SQL Server).