Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mone31
Starting Member
2 Posts |
 Posted - 2008-05-20 : 10:49:51
|
| Hi all,Some days ago i got a big Sql injection attack in one Sql Server 2000 database and today i got a big problem.The application were developed by a programmer no more in this company and the database is on a server i never seen. No backup at all and boom Sql Injection on that db inserting a script in place of the numerous articles in the archive. I have tried hundreds of tricks to get the job done but now i am in front of a wall. I got 5+ Gigas of Transaction Log but i can't face how can i restore the db at a point in time without an earlier full backup. Any ideas?Thanks in advanceMo |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-20 : 13:47:35
|
| You can not perform a point in time restore without a full backup. You must start with a full backup and then the entire transaction log chain after that backup up to and including the point in time you are interested in. You can include differentials in there as well, but you must have at least one full backup.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
Mone31
Starting Member
2 Posts |
Posted - 2008-05-21 : 03:03:52
|
| hello tkizer and thanks for the reply,the fact is that i don't have a preceding full backup and i can't perform the point in time restore for this db. What about ask directly with the Microsoft technical support? |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-05-21 : 11:47:37
|
| I don't think they are going to be able to do much either. You pretty much live and die with backups for DR purposes. Not to rub salt in your wounds but that should be your first priority when assuming a SQL server, make sure you have good, consistent backups that meet your business/SLA needs. Invest the money with a call to MS if you want but don't expect miracles.Terry |
|
|
|
|
|
|
Point in time recovery without an earlier full bak