haripadmam
Hot Shot
Hot Shot

vCenter SQL DB Recovery Model

Hi Folks,

Our infrastructure is having 7 node VMware cluster at both DC and DR. Seperate SQL DB server is used for vCenter, SRM and Update Manager.

Inventory (configuration) objects will not be changed frequently. Keeping this in mind I have selected 'simple' recovery model for all these DB.

Now reading Microsoft Ariticle saying in simple recovery model, data changed from last backup will not be recovered. Here I'm bit worried.

Whether Logs created after last backup is really important for recovery? Besides SQL agent based backup is scheduled on daily basis and also we are taking backup before and after any changed in VMware inventory. (like VM creation, VM configuration change, etc..)

Thank you in advance....

--

Hari

0 Kudos
6 Replies
psyclone1976
Contributor
Contributor

Check out page 2 here http://www.vmware.com/files/pdf/vc_microsoft_sql_server.pdf

It depends on how you want to set it up. Simple may not be the best option though.

iw123
Commander
Commander

I would agree with that, I dont believe simple is the best option.

*Please, don't forget the awarding points for "helpful" and/or "correct" answers
psyclone1976
Contributor
Contributor

Hello

Thank you for your message, I am out of the office in training all week.

If you need urgent assistance please contact David Wall, Rajesh Bharadia or call the Savvis Operations Centre (0118 3226100 Option 2)

Kind regards

Nick Marchini

This message contains information which may be confidential and/or privileged. Unless you are the intended recipient (or authorized to receive for the intended recipient), you may not read, use, copy or disclose to anyone the message or any information contained in the message. If you have received the message in error, please advise the sender by reply e-mail and delete the message and any attachment(s) thereto without retaining any copies.

0 Kudos
haripadmam
Hot Shot
Hot Shot

thank you guys... Now I'm planning to change the recovery model to Full and take daily backup (agent based)....

Any idea whether SQL logs will be automatically flushed to free up the space after every backup?

Thanks

Hari

0 Kudos
psyclone1976
Contributor
Contributor

Im no SQL expert but i think the logs get commited to the database when you do a full backup, you should also schedule frequent transaction log backup during the day so you can roll back to a certain period if you need to. Otherwise you will ony be able to restore to the most recent full backup.

0 Kudos
michal101
Contributor
Contributor

if you really want simply and best solution. then to recover the damage or corrupt database or to access the data from the inaccessible database you can simply go for recovery tool . you can take microsoft help also because it is the best.

http://www.microsoft.com/sqlserver/en/us/support.aspx

if you want to use recovery tool then you can use...http://www.stellarphoenixsqlrecovery.com

0 Kudos