UNSOLVED
ML
mtaylor-lfcu.co
4 Posts
0
27143
January 7th, 2009 15:00
How do I backup MS SQL databases and their transaction logs with Networker
How do I properly backup MS SQL databases and their transaction logs with Networker?
I'm currently running scheduled daily backups with Networker using the "nsrsqlsv.exe -T" backup command. The SQL server's dbs are set to 'Full' for their recovery model.
This seems to back up all the databases, but Enterprise manager reports that the transaction logs aren't backed up. I have to use NTbackup in order to see the logs being backed up.
How do I setup Networker to backup all the SQL databases and their transaction logs?
Should I be using the "nsrsqlsv.exe -R" command in conjunction with the "nsrsqlsv.exe -T" command?
I'm currently running scheduled daily backups with Networker using the "nsrsqlsv.exe -T" backup command. The SQL server's dbs are set to 'Full' for their recovery model.
This seems to back up all the databases, but Enterprise manager reports that the transaction logs aren't backed up. I have to use NTbackup in order to see the logs being backed up.
How do I setup Networker to backup all the SQL databases and their transaction logs?
Should I be using the "nsrsqlsv.exe -R" command in conjunction with the "nsrsqlsv.exe -T" command?
mtaylor-lfcu.co
4 Posts
7951
0
Posted January 8th, 2009 09:00
Do I run the incremental job using the "nsrsqlsv.exe -T" command? With some other switch or no switch at all?amediratta
2 Intern
•
2014 Posts
7951
0
Posted January 8th, 2009 09:00
You can create the schedule for incremental for the day and apply the schedule on the client/group resource.mtaylor-lfcu.co
4 Posts
7951
0
Posted January 8th, 2009 10:00
Yes, but what about the switch for the nsrsqlsv.exe? Do I need a switch or not? If so which one?amediratta
2 Intern
•
2014 Posts
7951
0
Posted January 8th, 2009 18:00
-T is meant only for Full backups. -R woul backup transaction logs in a NO_TRUNCATE mode. for levels, -l is the option but to be used only if you are running a client-initiated backup using the command line.
You can set incremental backup for SQL which backs up all transaction log changes since the last full, differential or transactional log backup. For SQL 2005, EMC also suggests using -H to backup transaction logs prior to database restore or primary filegroup restore.- I myself use a 3 group system for backuping MS SQL databases and transaction logs. One for full (in which I do 2 incr backups after the full), incr and diff which are run on different days. As for the backup command I use the savepnpc since I want to shrink the transaction logs after the backups are done and as for the backup command inside the scripts I use "nsrsqlsv.exe -l level -b pool MSSQL:" and osql command to shrink.
This has worked for me but there might be other "easier" ways to do it. - Dont use the switch, just the command. If you have not done so already create two schedules, one for Full's and one for Incremental aka Tlog to SQL. Create at least two clients for your SQL backups. On client A, select "Full" as the backup level, "MSSQL:" as the saveset and "nsrsqlsv" as the Backup Command.
When the backup starts Networker builds the environment for the job. It reads all the properties of the client and the group that the client is in to build the backup command.
Read the app log and you can see how this is done. - When you specify -T, it means truncate the logs hence it runs a full backups. I wouldn't use any flags at all and just let the Schedule take care of the backup level, Incremental backup will only backup Tlogs. Also, if you run any NTbackups in between, Legato loses track of the transaction logs and it forces a full backup so, make sure you are only using one application for backup.
HTH New to the Networker SQL module (NSM),
but just to confirm that if NSM is doing a Full backup @ 1800 after a SQL Maintenance Plan (SQLMP) completes a Full bkup @ 1600, then every hour, the SQLMP does a Trn Bkup, then the backups are going to be out of sync for restore purposes
Would I be correct in saying that if you had to restore @ 2200 after the NSM backup you would have to use the NSM and then the Trn Logs from the SQLMP? Appreciate any feedback
dpinink_silva
2 Intern
•
724 Posts
7947
0
Posted January 8th, 2009 02:00