can we get the deleted data back in SQL 2000

Hi im current using SQL 2000, data in three tables has got deleted on friday,
in the mean time some data is also get added into that tables. after two days
only i recognize the some data are deleted. No i need the deleted data and
also the newly inserted data. what should i do?
Sakthivel
SQL Server Developer
INDIA
Hi
Only if you have BACKUP LOG file issued during this period
"Sakthi" <Sakthi@.discussions.microsoft.com> wrote in message
news:ABD49489-6EC5-475B-ABB9-6F77B5A86903@.microsoft.com...
> Hi im current using SQL 2000, data in three tables has got deleted on
> friday,
> in the mean time some data is also get added into that tables. after two
> days
> only i recognize the some data are deleted. No i need the deleted data and
> also the newly inserted data. what should i do?
> --
> Sakthivel
> SQL Server Developer
> INDIA
|||http://www.karaszi.com/SQLServer/info_restore_log_several_times.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sakthi" <Sakthi@.discussions.microsoft.com> wrote in message
news:ABD49489-6EC5-475B-ABB9-6F77B5A86903@.microsoft.com...
> Hi im current using SQL 2000, data in three tables has got deleted on friday,
> in the mean time some data is also get added into that tables. after two days
> only i recognize the some data are deleted. No i need the deleted data and
> also the newly inserted data. what should i do?
> --
> Sakthivel
> SQL Server Developer
> INDIA
|||Yes, I have the backlog file. Everyday midnight the fullbackup will be taken
and stored.
Sakthivel
SQL Server Developer
INDIA
"Uri Dimant" wrote:

> Hi
> Only if you have BACKUP LOG file issued during this period
>
> "Sakthi" <Sakthi@.discussions.microsoft.com> wrote in message
> news:ABD49489-6EC5-475B-ABB9-6F77B5A86903@.microsoft.com...
>
>
|||Is the database in simple or full recovery model?
Are you doing regular transaction log backups?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sakthi" <Sakthi@.discussions.microsoft.com> wrote in message
news:9037CCBC-8515-44C0-9B51-64DA9B27F27C@.microsoft.com...[vbcol=seagreen]
> Yes, I have the backlog file. Everyday midnight the fullbackup will be taken
> and stored.
>
> --
> Sakthivel
> SQL Server Developer
> INDIA
>
> "Uri Dimant" wrote:
|||Thanks Tibor Karaszi and Uri
Sakthivel
SQL Server Developer
INDIA
"Tibor Karaszi" wrote:

> http://www.karaszi.com/SQLServer/info_restore_log_several_times.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sakthi" <Sakthi@.discussions.microsoft.com> wrote in message
> news:ABD49489-6EC5-475B-ABB9-6F77B5A86903@.microsoft.com...
>
>

can we get the deleted data back in SQL 2000

Hi im current using SQL 2000, data in three tables has got deleted on friday
,
in the mean time some data is also get added into that tables. after two day
s
only i recognize the some data are deleted. No i need the deleted data and
also the newly inserted data. what should i do?
--
Sakthivel
SQL Server Developer
INDIAHi
Only if you have BACKUP LOG file issued during this period
"Sakthi" <Sakthi@.discussions.microsoft.com> wrote in message
news:ABD49489-6EC5-475B-ABB9-6F77B5A86903@.microsoft.com...
> Hi im current using SQL 2000, data in three tables has got deleted on
> friday,
> in the mean time some data is also get added into that tables. after two
> days
> only i recognize the some data are deleted. No i need the deleted data and
> also the newly inserted data. what should i do?
> --
> Sakthivel
> SQL Server Developer
> INDIA|||http://www.karaszi.com/SQLServer/in...veral_times.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sakthi" <Sakthi@.discussions.microsoft.com> wrote in message
news:ABD49489-6EC5-475B-ABB9-6F77B5A86903@.microsoft.com...
> Hi im current using SQL 2000, data in three tables has got deleted on frid
ay,
> in the mean time some data is also get added into that tables. after two d
ays
> only i recognize the some data are deleted. No i need the deleted data and
> also the newly inserted data. what should i do?
> --
> Sakthivel
> SQL Server Developer
> INDIA|||Yes, I have the backlog file. Everyday midnight the fullbackup will be taken
and stored.
Sakthivel
SQL Server Developer
INDIA
"Uri Dimant" wrote:

> Hi
> Only if you have BACKUP LOG file issued during this period
>
> "Sakthi" <Sakthi@.discussions.microsoft.com> wrote in message
> news:ABD49489-6EC5-475B-ABB9-6F77B5A86903@.microsoft.com...
>
>|||Is the database in simple or full recovery model?
Are you doing regular transaction log backups?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sakthi" <Sakthi@.discussions.microsoft.com> wrote in message
news:9037CCBC-8515-44C0-9B51-64DA9B27F27C@.microsoft.com...[vbcol=seagreen]
> Yes, I have the backlog file. Everyday midnight the fullbackup will be tak
en
> and stored.
>
> --
> Sakthivel
> SQL Server Developer
> INDIA
>
> "Uri Dimant" wrote:
>|||Thanks Tibor Karaszi and Uri
Sakthivel
SQL Server Developer
INDIA
"Tibor Karaszi" wrote:

> http://www.karaszi.com/SQLServer/in...veral_times.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sakthi" <Sakthi@.discussions.microsoft.com> wrote in message
> news:ABD49489-6EC5-475B-ABB9-6F77B5A86903@.microsoft.com...
>
>

can we get the deleted data back in SQL 2000

Hi im current using SQL 2000, data in three tables has got deleted on friday,
in the mean time some data is also get added into that tables. after two days
only i recognize the some data are deleted. No i need the deleted data and
also the newly inserted data. what should i do?
--
Sakthivel
SQL Server Developer
INDIAHi
Only if you have BACKUP LOG file issued during this period
"Sakthi" <Sakthi@.discussions.microsoft.com> wrote in message
news:ABD49489-6EC5-475B-ABB9-6F77B5A86903@.microsoft.com...
> Hi im current using SQL 2000, data in three tables has got deleted on
> friday,
> in the mean time some data is also get added into that tables. after two
> days
> only i recognize the some data are deleted. No i need the deleted data and
> also the newly inserted data. what should i do?
> --
> Sakthivel
> SQL Server Developer
> INDIA|||http://www.karaszi.com/SQLServer/info_restore_log_several_times.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sakthi" <Sakthi@.discussions.microsoft.com> wrote in message
news:ABD49489-6EC5-475B-ABB9-6F77B5A86903@.microsoft.com...
> Hi im current using SQL 2000, data in three tables has got deleted on friday,
> in the mean time some data is also get added into that tables. after two days
> only i recognize the some data are deleted. No i need the deleted data and
> also the newly inserted data. what should i do?
> --
> Sakthivel
> SQL Server Developer
> INDIA|||Yes, I have the backlog file. Everyday midnight the fullbackup will be taken
and stored.
Sakthivel
SQL Server Developer
INDIA
"Uri Dimant" wrote:
> Hi
> Only if you have BACKUP LOG file issued during this period
>
> "Sakthi" <Sakthi@.discussions.microsoft.com> wrote in message
> news:ABD49489-6EC5-475B-ABB9-6F77B5A86903@.microsoft.com...
> > Hi im current using SQL 2000, data in three tables has got deleted on
> > friday,
> > in the mean time some data is also get added into that tables. after two
> > days
> > only i recognize the some data are deleted. No i need the deleted data and
> > also the newly inserted data. what should i do?
> > --
> > Sakthivel
> > SQL Server Developer
> > INDIA
>
>|||Is the database in simple or full recovery model?
Are you doing regular transaction log backups?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sakthi" <Sakthi@.discussions.microsoft.com> wrote in message
news:9037CCBC-8515-44C0-9B51-64DA9B27F27C@.microsoft.com...
> Yes, I have the backlog file. Everyday midnight the fullbackup will be taken
> and stored.
>
> --
> Sakthivel
> SQL Server Developer
> INDIA
>
> "Uri Dimant" wrote:
>> Hi
>> Only if you have BACKUP LOG file issued during this period
>>
>> "Sakthi" <Sakthi@.discussions.microsoft.com> wrote in message
>> news:ABD49489-6EC5-475B-ABB9-6F77B5A86903@.microsoft.com...
>> > Hi im current using SQL 2000, data in three tables has got deleted on
>> > friday,
>> > in the mean time some data is also get added into that tables. after two
>> > days
>> > only i recognize the some data are deleted. No i need the deleted data and
>> > also the newly inserted data. what should i do?
>> > --
>> > Sakthivel
>> > SQL Server Developer
>> > INDIA
>>|||Thanks Tibor Karaszi and Uri
--
Sakthivel
SQL Server Developer
INDIA
"Tibor Karaszi" wrote:
> http://www.karaszi.com/SQLServer/info_restore_log_several_times.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sakthi" <Sakthi@.discussions.microsoft.com> wrote in message
> news:ABD49489-6EC5-475B-ABB9-6F77B5A86903@.microsoft.com...
> > Hi im current using SQL 2000, data in three tables has got deleted on friday,
> > in the mean time some data is also get added into that tables. after two days
> > only i recognize the some data are deleted. No i need the deleted data and
> > also the newly inserted data. what should i do?
> > --
> > Sakthivel
> > SQL Server Developer
> > INDIA
>
>