Tuesday, February 21, 2012

Restore ...

1. I backedup databases from mssql7 default pathname with default pathname o
nto
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...
> sp_attach_db
>
>
>
actually several of them -- max of 16 per execution IIRC. Check out BOL
for more info
--
Graham (Pete) Berry
PeteBerry@.CalTech.edu

No comments:

Post a Comment