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 |
|
mdaniel
Starting Member
2 Posts |
 Posted - 2009-05-13 : 23:21:23
|
| i have the following problem. I have one production server and one failover server. The production server have one database with 150 gb and have two partition, one primary (recent data) and secondary (historic data) in different disc. Te production server is identically to failover, but the failover server is only maintained by restoring full backups. I want reduce the time to restore the fullbackup, only by restoring the recent data (primary) wich changing every day over the failover without doing the full restore, because the historic change less frequently.thanks |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-05-14 : 03:56:43
|
| Change your backup strategy to maybe one full backup a week and differentials each day, or look at log shipping or replication.It really depends on your environment and your SLA's. I think you may want to read up on backup strategies.http://msdn.microsoft.com/en-us/library/ms191239.aspx |
 |
|
|
mdaniel
Starting Member
2 Posts |
Posted - 2009-05-17 : 21:01:52
|
Thanks RickD. One thing is that to restore fullbackup in my case take 10 hours, it a lot of time. I have been testing to backup the two separete files (primary and secondary). And in case of problem, i will try to restore, first primary, to become online quick and then secondary, that have a lot of data and probably take more time to restore.quote:
Originally posted by RickD
Change your backup strategy to maybe one full backup a week and differentials each day, or look at log shipping or replication.It really depends on your environment and your SLA's. I think you may want to read up on backup strategies.http://msdn.microsoft.com/en-us/library/ms191239.aspx
|
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-05-18 : 04:29:04
|
| 150Gb shouldn't take that long to restore. Have you considered differentials instead as I said? |
|
|
|
|
|
|
Database restoring in different servers SQL 2005