SQLserver crashed.

[Former Member]

Experts:

We cannot start the SQL server any more. We plan to use the back up to recover.

According to the guide, we only need to select the most recent backup and click recover.

Since it is a production and we are doing it the first time, could you help confirm that's the only thing I need to do?

Thanks a lot!

[Former Member · Accepted solution]

> We cannot start the SQL server any more. We plan to use the back up to recover.

Please post errorlog content if you want to troubleshoot.

> According to the guide, we only need to select the most recent backup and click recover.

Yes, in management studio (2005) or enterprise manager (2000), make sure there's enough space in this drive.

[Former Member · Accepted solution]

The default path for the error log is:

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG

(unless you have installed SQL Server in other drive, look under MSSQL folder in that drive)