Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
manishsawant
Starting Member
2 Posts |
 Posted - 2009-02-15 : 00:11:01
|
| We are planning to have a high end server for VMware, create partitions in it and each partition will contain sql server database. As per the company policy we are supposed to take database backup on DAT every day by EOD. I want to have a good backup and restore plan for this type of setup. Your suggestions would be highly appreciated.Thanks,Manish |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-15 : 14:07:34
|
| Use Maintenance plan to backup your databases to local disks. Transfer your backups from local disk to tape(offsite location) for DR purposes. |
 |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2009-02-16 : 13:42:48
|
quote:
Originally posted by manishsawant
We are planning to have a high end server for VMware, create partitions in it and each partition will contain sql server database. As per the company policy we are supposed to take database backup on DAT every day by EOD. I want to have a good backup and restore plan for this type of setup. Your suggestions would be highly appreciated.Thanks,Manish
I don't care what type of server or partitioning you are planning to have but you SHOULD have a backup plan in process. Daily fulls, weekly diffs, log backups, whatever....does it fit you business needs?? Bascially, too open-ended a question to give an appropriate response. What exactly are you trying to accomplish?Terry-- Procrastinate now! |
|
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2009-02-16 : 13:48:40
|
| Treat each VMWare appliance as it's own database server (because that's what it is). Configure backups like you would any other database server. Some people use third party solutions, others have SQL Server do the backups via maintenance plans or scripts and SQL jobs. |
|
|
|
manishsawant
Starting Member
2 Posts |
Posted - 2009-02-16 : 15:13:16
|
| Thanks for your reply. I have one VMware server with 8 partitions and 7 databases on it. I have jobs in each partition which take backup and the backups are getting copied on the 8th partition which is only for dumping the 7 backup files. The 8th partition is mapped to a machine which has a dat drive and where we take backup on dat using ntbackup. Restoration would be the same cumbersome process. I wanted to have a much easy and automated process than what i have currently. We have around 500 business partners. Some are banks who have multiple servers and are always connected to us as we being the government body. We have to give the business partners a solution of using VMware so that they can use one setup rather than multiple servers which makes it is easy to maintain. Everything is in place except the backup and recovery plan. I guess this gives you an idea of what i am looking for.Thanks,Manish |
|
|
|
|
|
|
Database backup plan for a VMware setup