Host-based backup of VMware vSphere VMs.
Post Reply
tom11011
Expert
Posts: 192
Liked: 9 times
Joined: Dec 01, 2010 8:40 pm
Full Name: Tom
Contact:

MSSQL backups and replications question

Post by tom11011 »

Hi Group,

Have a few question on MSSQL backups and replications.

1.) Is the backup/replication of the Tempdb required in order to have good sql backups?

2.) We recently moved Tempdb to its own vmware disks which physically are on a different set of spindles to increase performance. Now that we have 2 vmware hard drives on this virtual machine, I notice that the backups/replications will process both hard drives simultaneously. Does that create a bigger performance strain having them both backed up at the same time?
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: MSSQL backups and replications question

Post by veremin »

1) As far as I'm aware, tempdb is not required, because it's being recreated each time sql service is started.

2) Increased number of disks means more data and more tasks need to be processed at the same time. Just make sure that proxy servers follow outlined system requirements.

Thanks.
tom11011
Expert
Posts: 192
Liked: 9 times
Joined: Dec 01, 2010 8:40 pm
Full Name: Tom
Contact:

Re: MSSQL backups and replications question

Post by tom11011 »

Is it possible to do a veeam backup and exclude tempdb?
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: MSSQL backups and replications question

Post by Vitaliy S. »

Hi Tom,

It should be possible to exclude databases from backup job by using these instructions > "Veeam v7- backing up vCenter's remote SQL VSS writer err", but I would double-check that with our support team.

Thanks!
Post Reply

Who is online

Users browsing this forum: No registered users and 89 guests