Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Backup up SQL Server

Status
Not open for further replies.

ervsplace

Technical User
Aug 23, 2001
61
US
Ordering the components to backup a SQL Server on W2k3.

This will not be a media server so right now I need:

1. remote agent
2. sql server agent

**Will I also need open file agent for this server? This server's primary role will be the sql database.


Erv
 
1. Yes
2. No, please don't.

Unless you really have to do it, don't use the Agent for SQL Server. I suggest doing SQL Server backups to disk and then using Backup Exec to copy those backup files to tape.

Either way you don't need the Open File Option.

-SQLBill
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top