Re: Detaching system databases...
From: Aaron Bertrand - MVP (aaron_at_TRASHaspfaq.com)
Date: 05/19/04
- Next message: Gregory A. Larsen: "Re: Delete Database Transaction Log File"
- Previous message: Van Jones: "Uninstall question, please help"
- In reply to: Todd: "Detaching system databases..."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 19 May 2004 11:49:09 -0400
Ugh, you can go through everything in KB #224071 and cross your fingers that
it all works well. Or, you can detach your *user* databases (or hopefully
you already have valid backups you can simply restore), uninstall SQL
Server, and then reinstall - placing the data directory where you should
have.
-- Aaron Bertrand SQL Server MVP http://www.aspfaq.com/ "Todd" <anonymous@discussions.microsoft.com> wrote in message news:f1c901c43db7$4ed332f0$a401280a@phx.gbl... > I need to detach (in order to move the datafiles) MASTER, > MSDB, MODEL, TEMPDB. I am using EM and the sp_detach > options om SQL Server 2000 but it's saying "Can't detach > system databases". Am I missing a step? > > Do I need to end all connections?? > > Thanks, > Todd
- Next message: Gregory A. Larsen: "Re: Delete Database Transaction Log File"
- Previous message: Van Jones: "Uninstall question, please help"
- In reply to: Todd: "Detaching system databases..."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
