Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

recover old data Expand / Collapse
Author
Message
Posted Wednesday, January 16, 2013 11:26 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Thursday, January 17, 2013 12:02 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:19 AM
Points: 1,101, Visits: 5,271
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
Posted Thursday, January 17, 2013 12:07 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:16 AM
Points: 20,465, Visits: 14,095
Do you have backups of your database?



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


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
Posted Thursday, January 17, 2013 12:12 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Thursday, January 17, 2013 12:17 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Thursday, January 17, 2013 12:19 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:16 AM
Points: 20,465, Visits: 14,095
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?




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


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 #1408179
Posted Thursday, January 17, 2013 12:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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.


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?



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
Posted Thursday, January 17, 2013 9:24 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:16 AM
Points: 20,465, Visits: 14,095
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/




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


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 #1408495
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse