Ellen-477471 (4/6/2010)

---

Found the files and the restore is complete.

We forgot to restore the log file from midnight -- '0000'

Now at least I know the backups are working correctly!

Thank...

I think mirorring would suit best. If the company wants to shell out little more money,...

Lynn Pettis (4/6/2010)

---

ps. (4/6/2010)

---

My gut feeling is that he is trying to learn the concepts rather than actually...

My gut feeling is that he is trying to learn the concepts rather than actually setting it up..

Lynn Pettis (4/6/2010)

---

Going to make this suggestion again, you may wish to consider hiring a consultant to help you.

It is difficult to provide you with the assistance you need over...

Steve Jones - Editor (4/6/2010)

---

I am not sure what Predeep means with that post, but you CANNOT have the same name in the DR site if this server is on...

Ok good. Do u have a SAN/NAS setup where u can keep ur databases? If yes, create few LUNs for ur databases and then setup the...

Unfortunately, for the past 1 year, i've been planning to go for certifications (starting with MCTS) but didnt give the exams... lol..

rkinney-802645 (4/6/2010)

---

I don’t have a test server for testing Clustering.

I have a second server (instance2) which has all the current SPs and Hot Fixes

I know, that in order to make...

I think there is some missing log backup file.

use this statement....

restore filelistonly from <your backup file>

Run this statement for ur differential backup and ur oldest log backup(just after diff backup)......

I dont think you CANNOT use same instance name on the DR server. This should not be a problem.

check if autogrowth is enabled for ur log files..

Ellen-477471 (4/6/2010)

---

Yesterday I needed to restore the full and differential and wanted to apply several hours of the log backups but could not get the logs to apply. It...

your database resides on a shared volume and at a given time only one of...

vendors do try to quote faily high amt of time required to perform a task. Show them actual duration of ur job and try to negotiate.