Re: URGENT (again) :-)
From: Peter (Peter.nospam_at_news.com)
Date: 03/29/04
- Next message: Amar: "Upgrade-- SQL server 6.5 on NT to SQL 2K on Windows 2K"
- Previous message: Tibor Karaszi: "Re: URGENT (again) :-)"
- In reply to: Tibor Karaszi: "Re: URGENT (again) :-)"
- Next in thread: Cindy Gross: "Re: URGENT (again) :-)"
- Reply: Cindy Gross: "Re: URGENT (again) :-)"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 29 Mar 2004 16:09:09 +0200
OK, thanks.
The user DBs are no problem using attach but the Master and the MSDB should
be nice if there were an easy way...
There isnīt any ready made script to do the procedure on these two system
databases?
Regards /Peter
"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
message news:%23pfTRNZFEHA.3404@TK2MSFTNGP10.phx.gbl...
> In general, you use sp_attach_db (and hopefully it works as attaching is
only supported if you actually
> detached the database first).
> However, the system databases are special... More info below:
>
>
> Moving SQL Server Databases
> http://www.support.microsoft.com/?id=224071
>
> Moving Databases between Servers
> http://www.support.microsoft.com/?id=314546
>
> Using WITH MOVE in a Restore to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465
>
> How To Transfer Logins and Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=246133
>
> Mapping Logins & SIDs after a Restore
> http://www.support.microsoft.com/?id=298897
>
> Utility to map users to the correct login
> http://www.dbmaint.com/SyncSqlLogins.asp
>
> How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
> http://www.support.microsoft.com/?id=240872
>
> User Logon and/or Permission Errors After Restoring Dump
> http://www.support.microsoft.com/?id=168001
>
> Disaster Recovery Articles for SQL Server
> http://www.support.microsoft.com/?id=307775
>
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
>
> "Peter" <Peter.nospam@news.com> wrote in message
news:eIOapEZFEHA.2576@TK2MSFTNGP11.phx.gbl...
> > Ok, now I have been able to get all the information from my crashed
server
> > and have installed anew one with the right parameters.
> >
> > NOw I have a file structure width MDF/LDF files for master, msdb,
userDBs
> > etc etc, how do I do restore from these files? E.G. there is no BAK
files in
> > place :-/
> >
> > Regards /Peter
> >
> >
>
>
- Next message: Amar: "Upgrade-- SQL server 6.5 on NT to SQL 2K on Windows 2K"
- Previous message: Tibor Karaszi: "Re: URGENT (again) :-)"
- In reply to: Tibor Karaszi: "Re: URGENT (again) :-)"
- Next in thread: Cindy Gross: "Re: URGENT (again) :-)"
- Reply: Cindy Gross: "Re: URGENT (again) :-)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
