Reattaching System Databases

I had to uninstall a SQL Server 2000 installation. Before I uninstalled it
I copied the Data directory to a different drive. After I reinstalled it I
copied my user databases back to the new Data directory and re-attached
them. My problem is I can not find a way copy the system databases back to
the new Data directory to re-attach them. I tried it with the Master.mdf
after shuting down SQL Server, but it wouldn't start back up. I do not have
a backup to restore from, only the .mdf and ldf files.
Is there a way to attach the old sytem database mdf and ldf files to the new
SQL Server installation.
Thanks
MikeAs a last ditch attempt, you could attach them as another database, perform a backup of the new database and then restore the master with the backup.|||Hi,
Instead of attaching the User databases perform the below steps,
After installation perform ,
1. Stop the SQL Server / SQL Agent service
2. Move all the new MDF and LDF to a new location (System databases)
3. Copy all the old MDF and LDF files back to the old location where the
files resides previously (Includes old System databases)
4. Start SQL server back
Thanks
Hari
MCDBA
"M Smith" <msmith@.avma.org> wrote in message
news:ONhB#8xzDHA.1740@.TK2MSFTNGP12.phx.gbl...
> I had to uninstall a SQL Server 2000 installation. Before I uninstalled
it
> I copied the Data directory to a different drive. After I reinstalled it
I
> copied my user databases back to the new Data directory and re-attached
> them. My problem is I can not find a way copy the system databases back
to
> the new Data directory to re-attach them. I tried it with the Master.mdf
> after shuting down SQL Server, but it wouldn't start back up. I do not
have
> a backup to restore from, only the .mdf and ldf files.
> Is there a way to attach the old sytem database mdf and ldf files to the
new
> SQL Server installation.
> Thanks
> Mike
>