DavidB (2/6/2009)

---

I would start with this link which is really BOL. I think you will find it to be pretty straightforward.

One note though, when they are mentioning using another...

DavidB (2/5/2009)

---

The production server will only incur a small hit with the log backups but that will provide you with better protection throughout the day and will eliminate the possibility...

David,

And this only pertains to the report db (disconnection). That is not an issue, since it will be done at midnight and most users turn computers off, but even...

2 Questions ?

1. What advantage does the log shippnig hourly vs once after working hours do for me.

2. What performance hit will the production server take if I...

I have local backups and network backups incase of failure. So it is pretty simple. They will have to reenter a day's worth of work if I...

David,

No I see where you are coming from. The one problem I had but i have still yet to relate it to issue that I am currently working with...

Funny you bring up snapshot, I read a little about this, but i was not sure if it you meet my needs (ie snap a shot of production server and...

My database is about 6gig and I would agree with your second option (being it's a little eaiser and I can detach and do all the db functions i need...