Save Set Question with Exchange and SQL

Question

Hello,

I am new to NetWorker and need some advice on backing up Exchange and MSSQL. I currently have Exchange and MSSQL servers with the NetWorker and Exchange/MSSQL modules. What is the best backup strategy so I can backup all data on these servers? I understand that if the Save Set is set to MSEXCH:IS that the system is only backing up the Information Stores and not the rest of the server like the System State. I assume this is the exact same for a Save Set of MSSQL for the SQL servers. Should I create two separate backup clients for each server? One with a Save Set of ALL and the other client for MSEXCH:IS or can I just use ALL to backup everything? Can I use ALL and MSEXCH:IS together as one Save Set option? Thanks

dugans1 · Answer

Hi Jason,

I guess you need to find out what firstly the app team if you have one require for SQL.

Also what does your company think about exchage.

I personally take the exchange store and public folders only if it is exchange 2003. I find it easier to rebuild the exchange box and mount the store than continually backup the whole lot. It's faster and less data to traverse the network.

SQL we do flat file. So the SQL server does a backup out to disk of the DB's and then i just pickup these bck files and putthem to tape. We also use SQL Light Speed for this.

Using ALL in the save set option will backup the whole box, if thats what you want? Yes you will need to create 2 jobs/clients for the same box if you want to do this. For some of my app servers i have to do this as they want the data backed up daily but the system bacjed up weekly or monthly. I just have a schedule for one job then a schedule for the other and say job one runs daily with job 2 running on the 1ST or 2ND of the month. I create a skip for job one on the 1st and skip all the other days on job 2. job 2 has the all save set and job one just take the core requirement.

I hope this helps, all the best.

rovinabi · Answer

Hi Jason,

You will have to create two different client resourcs for backing up the live application data and file system data. This is because the binaries used for the backup is different. It is always best to backup in the filesystem and the module data at two different times. HTH.

Rovin D'Souza.

elvinperez · Answer

Hello Must create a client for each SaveSet, ie one for the saveset and one for all, msexch:is, msexch:mb and mssql:. Regards, Elvin...

Jason_Williams1 · Answer

Hello, I just wanted to thank all of you guys for helping me out on this.

NetWorker

Save Set Question with Exchange and SQL

Was this post helpful?