Help Restoring SQL 7

I have a SQL 7 Server that crashed and I don't have a backup of the data. I
do have the data directory that held the database. How can I get my database
running again? I have reinstalled SQL and tried to overwrite the existing
data directory but that didn't work. Can anyone help me?
If you have all of the database files, primary (.mdf), secondary (.ndf), but
especially the log file(s) (.ldf), then after you've reinstalled, you can use
the primary file (.mdf) to sp_attach_db.
This will do recovery on the database; so, you might want to use copies of
the files at first. If there is corruption, you will need to get with MS PSS
to see if there is a way for them to recover it.
Sincerely,
Anthony Thomas
"New2SQL" wrote:

> I have a SQL 7 Server that crashed and I don't have a backup of the data. I
> do have the data directory that held the database. How can I get my database
> running again? I have reinstalled SQL and tried to overwrite the existing
> data directory but that didn't work. Can anyone help me?

Help Restoring SQL 7

I have a SQL 7 Server that crashed and I don't have a backup of the data. I
do have the data directory that held the database. How can I get my databas
e
running again? I have reinstalled SQL and tried to overwrite the existing
data directory but that didn't work. Can anyone help me?If you have all of the database files, primary (.mdf), secondary (.ndf), but
especially the log file(s) (.ldf), then after you've reinstalled, you can us
e
the primary file (.mdf) to sp_attach_db.
This will do recovery on the database; so, you might want to use copies of
the files at first. If there is corruption, you will need to get with MS PS
S
to see if there is a way for them to recover it.
Sincerely,
Anthony Thomas
"New2SQL" wrote:

> I have a SQL 7 Server that crashed and I don't have a backup of the data.
I
> do have the data directory that held the database. How can I get my datab
ase
> running again? I have reinstalled SQL and tried to overwrite the existing
> data directory but that didn't work. Can anyone help me?

Help Restoring SQL 7

I have a SQL 7 Server that crashed and I don't have a backup of the data. I
do have the data directory that held the database. How can I get my database
running again? I have reinstalled SQL and tried to overwrite the existing
data directory but that didn't work. Can anyone help me?If you have all of the database files, primary (.mdf), secondary (.ndf), but
especially the log file(s) (.ldf), then after you've reinstalled, you can use
the primary file (.mdf) to sp_attach_db.
This will do recovery on the database; so, you might want to use copies of
the files at first. If there is corruption, you will need to get with MS PSS
to see if there is a way for them to recover it.
Sincerely,
Anthony Thomas
"New2SQL" wrote:
> I have a SQL 7 Server that crashed and I don't have a backup of the data. I
> do have the data directory that held the database. How can I get my database
> running again? I have reinstalled SQL and tried to overwrite the existing
> data directory but that didn't work. Can anyone help me?

Help Restore Database

The drive where my SQL backup were being backed up had filled up last
wednesday. The drive that the MDF was on crashed but I still have the LDF on
a different drive and wednesday's backup on it. Will it still be possible to
get the data back if I restore its last complete backup and then some how
restore the current LDF?
> The drive where my SQL backup were being backed up had filled up last
> wednesday. The drive that the MDF was on crashed but I still have the LDF
on
> a different drive and wednesday's backup on it. Will it still be possible
to
> get the data back if I restore its last complete backup and then some how
> restore the current LDF?
Try to backup the last log with NO_TRUNCATE option first, and then do the
restore, including the last log backup. This way you might be able to
restore everything up to crash. Check the option mentioned in Books OnLine.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
|||Did the transaction log contain all transactions since the last full
database backup? If not, is the database set to FULL or BULK LOAD RECOVERY
or SIMPLE RECOVERY? Have there been transaction log backups?
Do as Dejan says and attempt a BACKUP LOG ... WITH NO_TRUNCATE to get all
committed transactions out.
You will need the database to NOT be in SIMPLE RECOVERY. You will need the
full transaction log and all log backups from the time of the last GOOD FULL
DATABASE backup.
You might be able to use a tool like Lumigent's Log Explorer to rewrite
transactions from the transaction log and replay against a restored
database.
Sincerely,
Anthony Thomas

"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
message news:O6fE$$SAFHA.2676@.TK2MSFTNGP12.phx.gbl...
> The drive where my SQL backup were being backed up had filled up last
> wednesday. The drive that the MDF was on crashed but I still have the LDF
on
> a different drive and wednesday's backup on it. Will it still be possible
to
> get the data back if I restore its last complete backup and then some how
> restore the current LDF?
Try to backup the last log with NO_TRUNCATE option first, and then do the
restore, including the last log backup. This way you might be able to
restore everything up to crash. Check the option mentioned in Books OnLine.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com

Help Restore Database

The drive where my SQL backup were being backed up had filled up last
wednesday. The drive that the MDF was on crashed but I still have the LDF on
a different drive and wednesday's backup on it. Will it still be possible to
get the data back if I restore its last complete backup and then some how
restore the current LDF?> The drive where my SQL backup were being backed up had filled up last
> wednesday. The drive that the MDF was on crashed but I still have the LDF
on
> a different drive and wednesday's backup on it. Will it still be possible
to
> get the data back if I restore its last complete backup and then some how
> restore the current LDF?
Try to backup the last log with NO_TRUNCATE option first, and then do the
restore, including the last log backup. This way you might be able to
restore everything up to crash. Check the option mentioned in Books OnLine.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||Did the transaction log contain all transactions since the last full
database backup? If not, is the database set to FULL or BULK LOAD RECOVERY
or SIMPLE RECOVERY? Have there been transaction log backups?
Do as Dejan says and attempt a BACKUP LOG ... WITH NO_TRUNCATE to get all
committed transactions out.
You will need the database to NOT be in SIMPLE RECOVERY. You will need the
full transaction log and all log backups from the time of the last GOOD FULL
DATABASE backup.
You might be able to use a tool like Lumigent's Log Explorer to rewrite
transactions from the transaction log and replay against a restored
database.
Sincerely,
Anthony Thomas
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:O6fE$$SAFHA.2676@.TK2MSFTNGP12.phx.gbl...
> The drive where my SQL backup were being backed up had filled up last
> wednesday. The drive that the MDF was on crashed but I still have the LDF
on
> a different drive and wednesday's backup on it. Will it still be possible
to
> get the data back if I restore its last complete backup and then some how
> restore the current LDF?
Try to backup the last log with NO_TRUNCATE option first, and then do the
restore, including the last log backup. This way you might be able to
restore everything up to crash. Check the option mentioned in Books OnLine.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com

Help Restore Database

The drive where my SQL backup were being backed up had filled up last
wednesday. The drive that the MDF was on crashed but I still have the LDF o
n
a different drive and wednesday's backup on it. Will it still be possible t
o
get the data back if I restore its last complete backup and then some how
restore the current LDF?> The drive where my SQL backup were being backed up had filled up last
> wednesday. The drive that the MDF was on crashed but I still have the LDF
on
> a different drive and wednesday's backup on it. Will it still be possible
to
> get the data back if I restore its last complete backup and then some how
> restore the current LDF?
Try to backup the last log with NO_TRUNCATE option first, and then do the
restore, including the last log backup. This way you might be able to
restore everything up to crash. Check the option mentioned in Books OnLine.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||Did the transaction log contain all transactions since the last full
database backup? If not, is the database set to FULL or BULK LOAD RECOVERY
or SIMPLE RECOVERY? Have there been transaction log backups?
Do as Dejan says and attempt a BACKUP LOG ... WITH NO_TRUNCATE to get all
committed transactions out.
You will need the database to NOT be in SIMPLE RECOVERY. You will need the
full transaction log and all log backups from the time of the last GOOD FULL
DATABASE backup.
You might be able to use a tool like Lumigent's Log Explorer to rewrite
transactions from the transaction log and replay against a restored
database.
Sincerely,
Anthony Thomas
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:O6fE$$SAFHA.2676@.TK2MSFTNGP12.phx.gbl...
> The drive where my SQL backup were being backed up had filled up last
> wednesday. The drive that the MDF was on crashed but I still have the LDF
on
> a different drive and wednesday's backup on it. Will it still be possible
to
> get the data back if I restore its last complete backup and then some how
> restore the current LDF?
Try to backup the last log with NO_TRUNCATE option first, and then do the
restore, including the last log backup. This way you might be able to
restore everything up to crash. Check the option mentioned in Books OnLine.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com

Help restore a database!

Hi SQL gurus!
My PC crashed but was able to recover some of my data including the
directory and folder with SQL Server 2000. I bought a new PC and want
to restore some of my databases. I tried to create a new database with
the same name and then copy and paste data and log files to a Data
folder but the system wouldn't allow me to do that. Is there any other
way to use my data and log files to restore datbases on the new PC?

Many thanks!

Stan

suslishe@.mail.ruTry using sp_attach_db to attach the database files. For example:

EXEC sp_attach_db
'MyDatabase',
'C:\DataFiles\MyDatabase.mdf',
'C:\LogFiles\MyDatabase_Log.ldf'

Note that this may not work since your databases were not cleanly detached
using sp_detach_db. You may get lucky, though.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Suslishe" <suslishe@.netscape.net> wrote in message
news:d404c196.0312121220.20ef44be@.posting.google.c om...
> Hi SQL gurus!
> My PC crashed but was able to recover some of my data including the
> directory and folder with SQL Server 2000. I bought a new PC and want
> to restore some of my databases. I tried to create a new database with
> the same name and then copy and paste data and log files to a Data
> folder but the system wouldn't allow me to do that. Is there any other
> way to use my data and log files to restore datbases on the new PC?
> Many thanks!
> Stan
> suslishe@.mail.ru