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 |
|
mparter
Yak Posting Veteran
86 Posts |
 Posted - 2005-03-17 : 14:03:03
|
See this topic for background >> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47124I'm now thinking about when it comes to a restore. tduggan states that I don't need to backup the database outside of the Log Shipping job. Say, 3 months down the line, my production database gets corrupted, do I have to restore the initial database backup from the standby server and then restore all the individual tlogs for the last 3 months? Sounds ludicrous!!If the server breaks, we can restore a 0-day image of that server onto another physical server, this will also have an 0-day copy of the production database. What's the best way of getting that back up-to-date?Sorry for the newbie questions, I've been thrown in at the deep-end on this one  |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-17 : 14:38:29
|
| In the log shipping wizard setup, you tell it how often to perform full backups. We do ours once per day and then tlogs every 15 minutes. The only problem with log shipping is that the full backups aren't copied over to the standby server, so you'll need to setup a separate job for that. We use xcopy to get them over. So anyway, my point is that log shipping takes care of the full backup for you already. Just make sure you do it often enough in case of a restore.I don't know what a 0-day image is.Tara |
 |
|
|
mparter
Yak Posting Veteran
86 Posts |
Posted - 2005-03-17 : 15:07:03
|
| OK, so I basically have a couple of options.1. I can include a database backup x amount of times per day and then create another job to ship this over to the standby servers.or2. I can backup the read-only standby database on one of the standby servers, copy this across to the re-built production server and then restore it.I don't even know if the 2nd one is possible, just hypothesising! Can you backup a read-only/standby database? The 2nd options probably less hassle if it's possible.An 0-day image is basically a snapshot/ghost of the whole server (OS, apps, etc) once it's been initially setup the way you want it so that you can rebuild another server with the same settings should you ever need to. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-17 : 15:57:16
|
| Yes you should be able to backup a read-only database. I prefer to do it on production though as that's where the restore would be happening.Tara |
|
|
|
|
|
|
|
|
Still confused ???