Restore ...

1. I backedup databases from mssql7 default pathname with default pathname onto
tape.
2. I installed sql 2000 server onto another computer.
3. I restored data into the default directory that was created with MSSQL7
c:\...\MSSQL7\... from tape created in step 1.
4. In Enterprise Manager for sql 2000, I do see default databases. But I
don't see the ones I restored.
5. How can I view the databases I backed up in step 1? I have over 50
databases.
Thank you for your help!
-Me"Me" <Me@.discussions.microsoft.com> wrote in message
news:5AAF668E-EACB-422E-8F64-5B4AB1DE0EB5@.microsoft.com...
> 1. I backedup databases from mssql7 default pathname with default pathname
> onto
> tape.
> 2. I installed sql 2000 server onto another computer.
> 3. I restored data into the default directory that was created with MSSQL7
> c:\...\MSSQL7\... from tape created in step 1.
> 4. In Enterprise Manager for sql 2000, I do see default databases. But I
> don't see the ones I restored.
> 5. How can I view the databases I backed up in step 1? I have over 50
> databases.
sp_attach_db
> Thank you for your help!
> -Me
>
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||In article <OcYIPMnjHHA.3472@.TK2MSFTNGP04.phx.gbl>,
mooregr_deleteth1s@.greenms.com says...
> "Me" <Me@.discussions.microsoft.com> wrote in message
> news:5AAF668E-EACB-422E-8F64-5B4AB1DE0EB5@.microsoft.com...
> > 1. I backedup databases from mssql7 default pathname with default pathname
> > onto
> > tape.
> > 2. I installed sql 2000 server onto another computer.
> > 3. I restored data into the default directory that was created with MSSQL7
> > c:\...\MSSQL7\... from tape created in step 1.
> > 4. In Enterprise Manager for sql 2000, I do see default databases. But I
> > don't see the ones I restored.
> > 5. How can I view the databases I backed up in step 1? I have over 50
> > databases.
> sp_attach_db
>
> >
> > Thank you for your help!
> > -Me
> >
> >
> >
>
>
actually several of them -- max of 16 per execution IIRC. Check out BOL
for more info
--
Graham (Pete) Berry
PeteBerry@.CalTech.edu