Recovery of database

By mistake I deleted the my application database, and I dont have Back up
also...
is there any way to recover it...
Please help me.. its very urgent
--
Regards,
Prashant COops, no backups!!!
Then its gone...
--
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"Prashant C" wrote:
> By mistake I deleted the my application database, and I dont have Back up
> also...
> is there any way to recover it...
>
> Please help me.. its very urgent
> --
> Regards,
> Prashant C|||Unless some Widows utility can recovery the deleted database files. If so, you could try
sp_attach_db for the files, but that is not guaranteed.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Sreejith G" <SreejithG@.discussions.microsoft.com> wrote in message
news:050D39A3-1771-46C4-A3A2-79E016B1E150@.microsoft.com...
> Oops, no backups!!!
> Then its gone...
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread and time
> asking back if its 2000 or 2005]
>
> "Prashant C" wrote:
>> By mistake I deleted the my application database, and I dont have Back up
>> also...
>> is there any way to recover it...
>>
>> Please help me.. its very urgent
>> --
>> Regards,
>> Prashant C

Recovering the deleted Table

Hi,
I have deleted the table from sql server2000 database by mistake. Is there any way to recover it?It's very urgent.
Thanks in advance.Q1 I have deleted the table from sql server2000 database by mistake. Is there any way to recover it?It's very urgent.


A1 Yes.

1 Restore the most recent DB backup dump to a differently named DB. For example: TestDB

2 Use a script and an insert statement, or DTS, or a select into statement, etc., to 'copy' (recreate & populate) the table back to the production DB from the TestDB. Depending on the technique used you may need to reapply permissions, constraints, etc., etc..|||Hi,
My problem is I don't have the back up of it. Is there any other way say by using the log file or any other?
Thanx|||Q1 I don't have the back up of it. Is there any other way say by using the log file or any other?

A1 If ddl scripts for the table(s) exist somewhere, the dropped tables may be recreated by running them.

As far as using the log for recovery, the answer is generally no. However, (provided certain conditions are met), a product like log explorer may sometimes be of help in addressing such kinds of situations. {Such products and methods are not a substitute for backup dumps.} See: http://www.lumigent.com/products/le_sql/le_sql.htm|||Data saved to LDF (LOG) files depend on recovery schema used.
MDF stores current (commited) state of database.
In full recovery schema, LDF stores all ops after last backup.
Then LDF can be used to locate changes and MDF can contain
deleted data.

That was theory...
Does anybody know somebody able to display info stored in SQL database binaries ...|||Originally posted by ispaleny
Does anybody know somebody able to display info stored in SQL database binaries ...
So DBA does.sql

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?
GavThe "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
>|||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...
> > 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.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||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
> 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...
> > > 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
> > >
> > >
> >
> >
>|||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
> 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
> > 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...
> > > > 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
> > > >
> > > >
> > >
> > >
> >
> >
>

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
>

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?
GavThe "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.b
tinternet.com...
> I have a fairly large database (225Gb) on a test server. The OS (NT 4) dri
ve
> 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...
drive[vbcol=seagreen]
>|||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
> message news:#QnWSIYPEHA.1048@.tk2msftngp13.phx.gbl...
> you first did sp_detach_db, but it
> news:c8f7u9$ipt$1@.sparta.btinternet.com...
> drive
I[vbcol=seagreen]
>|||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
> 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[vbcol=seagreen]
>