VMware Cloud Community
mdelfraro
Contributor
Contributor

configuration of data base of the SQL server

HI,

which best configuration for the archives of database of the SQL Server 2005.

thank.

Marcelo

0 Kudos
9 Replies
Dave_Mishchenko
Immortal
Immortal

Are you refering to the database for VirtualCenter? If you want to keep things simple, set the database recovery model to simple and then you only have to worry about running full database backups. The backup could be scheduled to run nightly and you could keep 2 or 3 days worth of backups on disk before deleting them. The backups you take to disk should then be backed up to tape as well.

If you have to recovery a databse to a more recent time frame and couldn't afford to go back to the previous full backup, then you would want to set the recovery model to full. you would then need to schedule a full backup (could be nightly or at the end of the business day) and then also schedule transaction logs backup jobs to run more frequently. The frequency of the transactions log backup jobs would depend on the importance of the database. For a more critical database, you might want to run the transaction log backups every 15 minutes. In the case of a database failure, you could recover the database and loose only 15 minutes worth of work. Again and depending on your needs, 2 or 3 days worth of backups on disk should suffice and you should also backup the full and transaction log backup files to tape.

0 Kudos
mdelfraro
Contributor
Contributor

the archives .mdf and .ldf must be configured in harddisk separate? I can create one harddisk of 500gb and place all the banks in this HD.

thank.

Marcelo

0 Kudos
Dave_Mishchenko
Immortal
Immortal

The database file (MDF and NDFs) and the transaction log file (LDF) can be on the some harddisk.

Typically you would seperate those onto seperate disks for

1) performance reasons

2) enhanced recovery (recovering up to the minute transactions from the transaction log should the harddisk hosting the MDF file fail).

0 Kudos
mdelfraro
Contributor
Contributor

it is possible to execute backup of only one bank with the VMCB?

thank.

Marcelo

0 Kudos
Dave_Mishchenko
Immortal
Immortal

Do you mean with VCB (consolidated backup)? If so, VCB would capture a snapshot of VM, but you would still need to agment your VCB backup with smoe sort of SQL backup.

The VCB backup would capture the database files in a state in which SQL Server would most likely be able to recover the databases if you did a restore (it would be like pulling the power plug on your SQL Server VM). But I would definitely backup the database outside of VCB as well.

0 Kudos
michaeljames
Contributor
Contributor

I would like to share my experience with this tool that which was assisted me to recover my SQL Server database. You can download this tool from:-  http://www.pcrecoverytools.com/sql-database-recovery.html

0 Kudos
robotdecocinato
Contributor
Contributor

Maybe this can help someone on configuration SQL Server:

https://confluence.atlassian.com/display/DOC/Database+Setup+for+SQL+Server

0 Kudos
expreess1
Contributor
Contributor

Try more reliable and advance SQL Database Recovery software. This software easy to recover all SQL data including tables, stored procedure, functions, views, rules, triggers and associated Primary Key, Unique keys, etc. Read more information and free download click here http://utilitysoftwarereview.com/sqldatabaserepair.html

0 Kudos
xiuxiuchiu
Contributor
Contributor

I suggest you to use SQL database software that is specially designed for such purposes. You can try their demo version and they apparently show you the recovered database, and if you do see your deleted tables then you can safely save them too.

 

Download:-  SQL Database Recovery Software to Restore Corrupt MDF Database File

0 Kudos