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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Legato SQL Module

Status
Not open for further replies.

cxm

MIS
Joined
Mar 12, 2001
Messages
6
Location
US
Do I need to create a separate job to back my ms sql database using the legato sql module. Tried to use the nsrsqlsv command with a normal system backup and it failed.
 
We usually create a separate client for SQL. This way, I can get my normal NT backups, and have SQL backup at a different time/schedule. Create the client twice, specify "All" as the save set for one instance, and "MSSQL:" for the other.

As long as you have the SQL client installed on the SQL Server and enabled on the Legato server, all you have to do is specify MSSQL: (instead of "All") as the save set, NSRSQLSV as the remote command, and provide the username and password for the remote user (we use the "sa" account).

Should work fine 8-) - Bill

"You can get anything you want out of life, if you'll just help enough other people get what they want" - Zig Ziglar
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top