Restore database, please help

Undo for SQL Server.

Restore database, please help

Postby mcy » Fri Oct 07, 2005 6:39 pm

I posted a topic on the backup forum, it might belong here:
Posts: 2
Joined: Thu Oct 06, 2005 11:46 pm

Postby Brian Donahue » Mon Oct 10, 2005 9:13 am

Hello there,

I'd definitely recommend giving SQL Log Rescue a try anyway, even if you do not have a full backup.

If your live database log goes back to the time that the tables were created, you may be able to get them back. The reason that SQL Log Rescue requires a full backup normally is to get the schema information for the database, but if, as you say, you don't believe that the log had ever been cleared, then there's a good possibility that you can get the tables back.

I would avoid backing this database up at this point in time, but once you think you've got all of the data back from log rescue I'd do a full backup at that point and definitely look into a regular backup strategy for the database.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Log Rescue

Who is online

Users browsing this forum: No registered users and 0 guests