Re: Re-installing SQL Server

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 08/04/04 

Date: Wed, 4 Aug 2004 08:31:41 -0400

Yes, you can backup and restore master, model, everything... But I think I
would open a PSS call to get MS support for this... Perhaps they can help
you get through without re-install... The cost is just $249 I think.. 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Alpha" <Alpha@discussions.microsoft.com> wrote in message
news:58D9149D-F7B0-423F-9EE7-CA7E1AC62C13@microsoft.com...
> I tried reinstalling sp3 twice and both time it won't go through.  The sql
server status shows it has SP3 when in fact the installation never went
through.  It is in a confused state.  I will be removing the sql server
installation, deleted the folder and then re-install from scratch.  I search
the on-line book for more detail of sp_help_revlogin but it is not found.
Is there a typo?
>
> Thanks,
> Alpha
>
>
>
> "Richard Ding" wrote:
>
> > Have you tried reinstalling sp3? If it still fails without a good
reason, I
> > highly recommend you starting reinstallation from scratch because the
> > previous failed sp install may have corrupted the SQL instance, or at
least
> > changed system schemas etc, leaving you in a inconsistent state. You can
run
> > sp_help_revlogin to script out all user logins and save them. Also
detach
> > all user dbs for future attach. You need to script out all jobs, alerts,
> > etc. also to avoid restoring msdb.
> >
> >
> > "Alpha" <Alpha@discussions.microsoft.com> wrote in message
> > news:3D37FDD1-7C11-4DAE-99A6-E2E12CC11A76@microsoft.com...
> > > A remote user messed up my installation of SQL SP3 and now the SQL
Server
> > property shows it has SP3 but in fact it never went though the process.
I'm
> > planning to re-isntll the SQL server then apply the SP3.
> > >
> > > Is there an article or can someone give me some pointers of
preparation
> > prior to removing the current SQL server.  Also, currently I only know
to
> > back up the database file.  Can I backup and restore the Master DB and
it
> > will retore all users' login and passwords to a particular database now
on
> > the server?
> > >
> > > Thanks,
> > > Alpha
> >
> >
> >

Relevant Pages

  • Re: Migrate SharePoint Portal 2003 and it DB Server to another ser
    ... I first applied WSS sp3, then rebooted then applied ... I have not rebooted my SQL server. ... Which order did you do the two SP3 installations? ... I am backing and restoring using the SharePoint backup and restore utility. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Save as in SQL Server(Backup - Restore)
    ... > SQL Server only support local drives for storing databases files (just as ... > Tibor Karaszi, SQL Server MVP ... >> device not supported for database files. ... >> RESTORE DATABASE is terminating abnormally. ...
    (microsoft.public.sqlserver.programming)
  • Re: Save as in SQL Server(Backup - Restore)
    ... SQL Server only support local drives for storing databases files. ... > device not supported for database files. ... > RESTORE DATABASE is terminating abnormally. ...
    (microsoft.public.sqlserver.programming)
  • Re: No boot after last set of auto updates
    ... Booted with old disk and tried to restore system registry file ... Started a Windows Update support incident ... update history shows the 10 updates as successful. ... Notebook PC running XP Pro SP3 and have always applied auto updates. ...
    (microsoft.public.windowsupdate)
  • Re: SP3 wont install - wont validate sa password
    ... Jasper Smith (SQL Server MVP) ... I support PASS - the definitive, ... "STom" wrote in message ... > i get to the point in the sp3 install, ...
    (microsoft.public.sqlserver.setup)