Recovering Database. Urgent.

I have a fairly large database (225Gb) on a test server. The OS (NT 4) drive
has died and I will have to reinstall it from scratch. My question is, I
still have the database files (SQL 7) intact is it possible for me to
reinstall everything, recreate the database and then point it at the
original database files?
Gav
The "point" part would be sp_attach_db. It is only documented to work if you first did sp_detach_db, but it
might work.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Gavin Metcalfe" <gavin.metcalfe@.btinternet.com> wrote in message news:c8f7u9$ipt$1@.sparta.btinternet.com...
> I have a fairly large database (225Gb) on a test server. The OS (NT 4) drive
> has died and I will have to reinstall it from scratch. My question is, I
> still have the database files (SQL 7) intact is it possible for me to
> reinstall everything, recreate the database and then point it at the
> original database files?
> Gav
>
|||Yes, look at sp_attachdb in BOL. Try to get SQL Server to the same patch
level as it was previously before doing this though.
Regards,
William D. Bartholomew
http://blog.bartholomew.id.au/
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Ok, how about if I create a new database, then stop the services and change
the files it has created for the old ones.
Gav
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:#QnWSIYPEHA.1048@.tk2msftngp13.phx.gbl...
> The "point" part would be sp_attach_db. It is only documented to work if
you first did sp_detach_db, but it
> might work.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Gavin Metcalfe" <gavin.metcalfe@.btinternet.com> wrote in message
news:c8f7u9$ipt$1@.sparta.btinternet.com...[vbcol=seagreen]
drive
>
|||Hi,
Yes, you can try that as well. In both the cases you have to create all your
logins , jobs, operators , linked server .....
Another approach which will give back your database server as same as old
stage:-
Once your hard disk drives are accessible, take the copy of MDF and LDF to a
new safe place and do the below steps.
To do this you should have all you system and user databases MDF and LDF
files.
1. Install Windows NT and Service packs. Name computer name as OLD name.
2. Install SQL 7 and install the service pack as old level. Ensure that you
install sql server
with same directory structure.
3. Stop SQL server and SQl sgent service
4. Copy all the MDF and LDF files , Ensure that you copy
the system database files for master, Model, tempdb, msdb databases
5. After the successful copy, start the SQl server
Mostly by doing this steps you can go back to old stage with all the
databases up.
Thanks
Hari
MCDBA
"Gavin Metcalfe" <gavin.metcalfe@.btinternet.com> wrote in message
news:c8f9be$2l9$1@.hercules.btinternet.com...
> Ok, how about if I create a new database, then stop the services and
change
> the files it has created for the old ones.
> Gav
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in[vbcol=seagreen]
> message news:#QnWSIYPEHA.1048@.tk2msftngp13.phx.gbl...
> you first did sp_detach_db, but it
> news:c8f7u9$ipt$1@.sparta.btinternet.com...
> drive
I
>
|||Thats is round about what I am planning to do. Database is too large for me
to move somewhere else so I'm going to rename the files to .old to start
with. It is a SAP database so I'm going to reinstall SAP and let it recreate
its standard database and then I'm planning to replace the new files with
the old.
Gav
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:#8zreRYPEHA.3264@.tk2msftngp13.phx.gbl...
> Hi,
> Yes, you can try that as well. In both the cases you have to create all
your
> logins , jobs, operators , linked server .....
> Another approach which will give back your database server as same as old
> stage:-
> Once your hard disk drives are accessible, take the copy of MDF and LDF to
a
> new safe place and do the below steps.
> To do this you should have all you system and user databases MDF and LDF
> files.
> 1. Install Windows NT and Service packs. Name computer name as OLD name.
> 2. Install SQL 7 and install the service pack as old level. Ensure that
you[vbcol=seagreen]
> install sql server
> with same directory structure.
> 3. Stop SQL server and SQl sgent service
> 4. Copy all the MDF and LDF files , Ensure that you copy
> the system database files for master, Model, tempdb, msdb databases
> 5. After the successful copy, start the SQl server
> Mostly by doing this steps you can go back to old stage with all the
> databases up.
> Thanks
> Hari
> MCDBA
>
>
>
> "Gavin Metcalfe" <gavin.metcalfe@.btinternet.com> wrote in message
> news:c8f9be$2l9$1@.hercules.btinternet.com...
> change
> in
if[vbcol=seagreen]
4)[vbcol=seagreen]
is,[vbcol=seagreen]
> I
to
>