Re: Can I restore msdb from another sqlserver 's backup

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 09/03/04 

Date: Fri, 3 Sep 2004 12:20:14 +0200

You should find info on this in KB 224071. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Karin W" <Karin W@discussions.microsoft.com> wrote in message
news:417700A9-7115-481C-8884-BA26136A8E93@microsoft.com...
> Hi,
>
> We have the same problem with a suspected MSDB.
> We tried to drop the msdb but got the message that the database cannot be
> droped because it'a a system database.
> How can we drop the database anyway and solve our problem?
>
> Best Regards,
> Karin W
>
> "Hari Prasad" wrote:
>
> > Hi,
> >
> > It is not required to restore the MSDB from another server. Best  option
> > will be drop the MSDB database and run the INSTMSDB.SQL script
> > from sql server installation directory\install folder.
> >
> > Follow the below steps:-
> >
> > 1. Login to sql server using query analyzer
> > 2. Drop the MSD database
> >
> >    DROP database MSDB
> >
> > 3. Open the INSTMSDB.SQL file in query analyzer
> >
> > 4. Just execute the script. This create the MSDB database,  ALL objects ,
> > .......
> >
> > 5. After the succesful execution you will get a fresh MSDB.
> >
> > Thanks
> > Hari
> > MCDBA
> >
> >
> > "StarNet" <anonymous@discussions.microsoft.com> wrote in message
> > news:9e5b01c4792d$3cf98050$a601280a@phx.gbl...
> > > My msdb,system database, of sqlserver is marked suspected,
> > > I cant recovery it for any method.
> > > Therefore, Can I restore it from another sqlserver's
> > > msdb backup?
> >
> >
> >

Relevant Pages

  • Re: Coping everything to New Server
    ... Are these brought in with the master or msdb database? ... Sames thing with the Backup devices under ... > original sql server. ...
    (microsoft.public.sqlserver.setup)
  • Re: Cant Install SP4 for SQL 2000 / Win2k3
    ... Looks like your msdb database has been marked as suspect. ... > See the SQL Server errorlog for more information." ...
    (microsoft.public.sqlserver.setup)
  • Re: Host Operating System Disaster
    ... The system MSDB database was what I was sweating ... One thing to try is to reinstall SQL Server to the same ... location they were at originally before the drives went out. ... explicitly detach the database first using sp_detach_db. ...
    (microsoft.public.sqlserver.setup)
  • Re: MSDB (Subspect)
    ... I have one more suggestion to this issue, I feel that during the MSDB mdf ... and LDF physical file copy (cold Backup), they would have started the SQL ... Stop & Start the SQL Server ... > Probably because the database was damaged when you took the backup. ...
    (microsoft.public.sqlserver.server)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)