Tony Fountain (10/9/2009)

---

Ok, for what it's worth... I found out I can simply rerun the latest service pack exe and it will also correct this problem... go figure - so...

It works after the reinstallation. The system database files location have to be same as the server where I restored the master database to.

Perry Whittle (4/5/2013)

---

You started the instance in single user minimal config...

Perry Whittle (4/4/2013)

---

If all the system database files have been wiped out, you cannot start in single user mode as SQL Server expects at least the master database to be...

dan-572483 (4/4/2013)

---

Clare:

Are we talking about SQL2008 or SQL2008 R2? The location of the setup file that rebuilds the system databases is different for R2, and the procedure is...

Perry Whittle (4/4/2013)

---

If all the system database files have been wiped out, you cannot start in single user mode as SQL Server expects at least the master database to be...

Bill (fluffydeadangel) (3/18/2013)

---

1. Is the "setup" file is still good to use if my sql server is patched to SP2 after installation?

If this is one of the system database files...

Thank you all! it went smoothly. All DBs are online and passed DBCC check.:-)

Steve,

This is not a new server. We will use the exsting server. Once the C drive is restored, the server should see other existing data, log, tempdb drives..

Hi Steve,

The C drive used storage from the bad SAN before. The plan is to have C drive use local stoage. Yes, all data and log files will be on...

Yeah, in theory it should work. But I never did it before, any suggestions during the process?

Thank you for all the replies!

The server team is going to use VMWare to clone SQL Servers to virtual machines. If the original SQL server is clustered, the cloned one...

you can set to get notification when job complete.

Thank you all for the information. The recreation of the AD account solve the probelm. Still not sure what happened.

still failed after reboot user's machine.