Hi,
I need to restore mater and msdb database on SQL Server.
When the network guy upgrade server from Windows NT 4.0 to
Windows 2000 Server, he massed up the C: drive so the
SQL installation is gone.
Because I've installed sql on D:\MSSQL folder,
necessary .mdf & .ldf files are in there.
However, because I didn't create backup file.
I'm trouble to restore master & msdb file.
The BOL said that I cannot attach database unless I
detached that database.
And also master & msdb databases are not allowed to detach.
I didn't tryed yet, but Can I just install SQL again and
overwrite .mdf & .ldf from old installation?
Does anyone successfully restored master without backup?
Any tip or advice would be helpful.
Thank you.
- Hyung -Make sure you save those files somewhere safe before doing anything to start
with. Have a look here. These explain how to fix most of your issues:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
--
Andrew J. Kelly
SQL Server MVP
"hrhoe" <hrhoe@.hotmail.com> wrote in message
news:01e401c39f0b$9658e250$a301280a@.phx.gbl...
> Hi,
> I need to restore mater and msdb database on SQL Server.
> When the network guy upgrade server from Windows NT 4.0 to
> Windows 2000 Server, he massed up the C: drive so the
> SQL installation is gone.
> Because I've installed sql on D:\MSSQL folder,
> necessary .mdf & .ldf files are in there.
> However, because I didn't create backup file.
> I'm trouble to restore master & msdb file.
> The BOL said that I cannot attach database unless I
> detached that database.
> And also master & msdb databases are not allowed to detach.
> I didn't tryed yet, but Can I just install SQL again and
> overwrite .mdf & .ldf from old installation?
> Does anyone successfully restored master without backup?
> Any tip or advice would be helpful.
> Thank you.
> - Hyung -|||Thank you,
I'll try those as soon as the Server is recovered.
- Hyung -|||Andrew,
I tried to rebuild master database after new SQL setup,
I got the error message:
"rebuild Master failed with error -1:
Do you know what this mean?|||No I don't. If you did a new install then why do you need to rebuild
Master?
--
Andrew J. Kelly
SQL Server MVP
"hrhoe" <hrhoe@.hotmail.com> wrote in message
news:020b01c39f31$3aa34ba0$a601280a@.phx.gbl...
> Andrew,
> I tried to rebuild master database after new SQL setup,
> I got the error message:
> "rebuild Master failed with error -1:
> Do you know what this mean?
>
