Paul White NZ (4/7/2010)

---

David Fulton-420388 (4/7/2010)

---

Paul White NZ (4/7/2010)

---

David Fulton-420388 (4/7/2010)

---

I'm in the camp that the DBA should maintain the data entered by the users. If data looks incorrect,...

george sibbald (4/7/2010)

---

David Fulton-420388 (4/7/2010)

---

I'm in the camp that the DBA should maintain the data entered by the users. If data looks incorrect, then bring it to the users'...

David Fulton-420388 (4/7/2010)

---

I'm in the camp that the DBA should maintain the data entered by the users. If data looks incorrect, then bring it to the users' attention and...

What are you trying to do? You should not need to touch this database in SQL2008, and certainly don't rename it.

Perry Whittle (4/7/2010)

---

george sibbald (4/7/2010)

---

Question I don't know the answer to............In SQL2008 if you restore a master database from a different server and the server the backup originated from had...

I guess my concerns with this approach are as much about restoring master across servers per se as the different drive layout.

another issue you could hit would be around...

David BAFFALEUF (4/6/2010)

---

Hi,

Just a quick word,

In SQL 2008 resource is not requested to be under the same location as master anymore. The resource files are stored in the binaries directory,...

Most Odd.

What is the value of the database_version column in msdb..backupset for each of these backups you are trying to restore?

I agree with Jason, that is not a SQL2000 backup you are trying to restore, as shown by the version nos in the error message.

Its telling you this backup is...

Perry Whittle (4/5/2010)

---

you can also perform a...

just disable all the logshipping jobs. Do your restore on primary and restore with norecovery on secondary.

delete all tran log backups on the secondary. Move any log backups on primary...

check out sp_helptext

nikhil.verma (4/4/2010)

---

Thanks a lot for replying.

In my Environment there is no high availability solution implemented.

In SP3 + CU1 do we get any benefits from Database administration point of...

bigM (4/3/2010)

---

Thanks George.

A question from my side is that if SP3 CU1 has SP2 CU10 and CU11, then how can we add the SP2 CU12 to CU17 after the SP3...

9.0.3353 appears to be SP2 + CU16 + some individual hotfix?

Are you applying CUs simply because they are being released or because you have hit an issue fixed in CU16?...