Jun 15, 2015

Fell RAID, how to restore SQL 2000 database?

Good day!
This morning fell RAID, on which lay the Database. Urgently need to recover the database. from bases there is a copy made at night by the built-in means.
I created new RAID. I restored structure of folders. Everything is exactly as it was. But, in a folder with the base course no .ldf and .mdf files. Created empty files. I wanted to fill in from a backup but I can't be connected to bases in Enterprise Manager. Fails with the following : A connection could not be established to (Local). Reason: Can not open user default database. Login failed. Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the (Local) node) and try again. Please help.....by morning need to work((((
Need to connect with a clear indication of the master database to connect to. Make default base the master base. In 2000 I do not remember, whether there are options when connection, but always remains osql.

SQL Server 2000 and SQL Server 7.0

You can use the osql utility to change the default database in SQL Server 2000 and in SQL Server 7.0. To do this, follow these steps:

At a command prompt, type the following and then press ENTER:

C:\>osql -E -d master

At the osql prompt, type the following and then press ENTER:

1>sp_defaultdb 'user's_login', 'master'

At the second prompt, type the following and then press ENTER:


Here http://support.microsoft.com/kb/307864/en-us

This article might be helpful:

SQL Server 2000 Backup and Restore
Answer this