recover old data

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » recover old data

recover old data

Rate Topic

Display Mode

Topic Options

Author

Message

fatinfzi

Posted Wednesday, January 16, 2013 11:26 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 02, 2013 9:54 PM
Points: 24, Visits: 88

Hi,

can anyone help me how to recover the old data from SQL database? The data in the database only lasts for 3months. Pleaseeeeeee this is very urgent.

Post #1408157

Suresh B.

Posted Thursday, January 17, 2013 12:02 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 4:49 AM
Points: 1,075, Visits: 5,119

Where is the old data? Was it deleted? Was it moved to some other database or server before deleting?

Restore the old backup as dbname_old. Then get the data from this db.

Post #1408171

SQLRNNR

Posted Thursday, January 17, 2013 12:07 AM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 10:25 AM
Points: 18,754, Visits: 12,337

Do you have backups of your database?

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1408175

fatinfzi

Posted Thursday, January 17, 2013 12:12 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 02, 2013 9:54 PM
Points: 24, Visits: 88

we do have backups but i'm not sure where to check why i can only see only the past 3months data.

Post #1408177

fatinfzi

Posted Thursday, January 17, 2013 12:17 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 02, 2013 9:54 PM
Points: 24, Visits: 88

the data supposed to be inside this one table. I just need the old data, from this particular table only.

Post #1408178

SQLRNNR

Posted Thursday, January 17, 2013 12:19 AM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 10:25 AM
Points: 18,754, Visits: 12,337

fatinnadiah88 (1/17/2013)

we do have backups but i'm not sure where to check why i can only see only the past 3months data.

If you have a backup of the database, then you need to restore that backup. Restore it as a different database and then copy the data from the restored database into the production database.

As per the 3 months of data - is there a purge process that is deleting everything older than 3 months?

Post #1408179

fatinfzi

Posted Thursday, January 17, 2013 12:53 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 02, 2013 9:54 PM
Points: 24, Visits: 88

SQLRNNR (1/17/2013)

fatinnadiah88 (1/17/2013)

we do have backups but i'm not sure where to check why i can only see only the past 3months data.

i dont think so. but if there's any, do you have any idea where can i check that? is it in the maintenance plan? or is there any other reason why?

sorry im very very new in this.

Post #1408191

SQLRNNR

Posted Thursday, January 17, 2013 9:24 AM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 10:25 AM
Points: 18,754, Visits: 12,337

It is possible that it would be in a maintenance plan. It is possible that it is being run through a 3rd party app. It is possible that there is a sql agent job running it. It is also possible that another person just run a tsql command for a 1-time backup.

Here is a script that can help you get a history on the backups
http://jasonbrimhall.info/2012/11/30/backup-history/

Post #1408495

« Prev Topic | Next Topic »

Permissions