April 23, 2008 at 2:35 pm
hi Guys..
i don't know i m stupid or somthing.. but somehow i deleted my company very improtant data.. and more over i hvn't take the backup of database..
Please help me out if any one of you guys know how can i recover the data.. i don't have a single back of this database...
Thanks .....
April 23, 2008 at 3:48 pm
If the database uses the full recovery model you could try one of the log reader/recovery tools. I hear RedGate has a free downloadable tool.
If the database uses the simple recovery model, I think you're out of luck.
Greg
April 24, 2008 at 12:28 am
If the database has never had a full backup, even in full recovery it won't keep the logs. There has to be a full backup taken before SQL starts retaining log entries.
Check the recovery mode of the DB. You can query sys.databases to find that.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 24, 2008 at 1:42 pm
Soapbox time...Please all DBAs. For your security, perform a backup of all databases as soon as they are created. It's just a good best practices thing to so. It will save you great embarassment when examples such as this happens.
Marvin Dillard
Senior Consultant
Claraview Inc
April 24, 2008 at 11:44 pm
*steals soapbox*
And make sure that said backups are restorable. There's nothing worse that tellng management that 'Everything's fne, we have recent backups', then finding that said backups are not restorable
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply