October 17, 2003 at 3:22 am
Hi All,
One of our user accidentally deleted all the tables. Please tell us as how to restore those tables. I have last months backup only. I am using SQL 2k in 2k server.
Thanks in advance,
Rahul
October 17, 2003 at 3:31 am
Hi Rahul,
quote:
One of our user accidentally deleted all the tables. Please tell us as how to restore those tables. I have last months backup only. I am using SQL 2k in 2k server.
if you haven't added other objects like views, stored procedures...to that database it might be the easiest solution to delete the whole db and restore again from the last backup.
In addition to that, you should review your security strategy (a normal user shouldn't have that escalated permissions. Kick him!) and your backup strategy (you have just lost a month of data).
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
October 17, 2003 at 4:40 am
Hi Frank,
Thanks for the quick reply, I could restore from the last month backup but what about my one month data? Can I recover that? till today morning I have the log file.
Rahul
October 17, 2003 at 5:25 am
If you have your logfile you should be able to restore it by using RESTORE LOG.
Check BOL for complete syntax or take a look at logs-> applying backup when using EM and RESTORE LOG -> How to apply a transaction log backup!
If the log file hasn't been truncated since last backup you'll have a good chance to recover your data.
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
October 17, 2003 at 5:44 am
Before you do anything else, BACKUP that log file!
Whenever you have a crash/data loss/failure/etc you should backup the existing log if possible.
Then do as Frank suggested, restore the database and logs. Make sure you use the WITH NORECOVERY option on all but the last RESTORE.
-SQLBill
October 19, 2003 at 9:55 pm
it depends on the "recovery model" you picked. if you didn't "pick one", then you probably defaulted to "simply recovery".. which is basically, BACKING UP and .. (if something happens) RESTORING the file.
you're learning the hard way dude. 1 month old is TOO OLD.
..
If you go to "Management", "Database Maintenace Plans", you can have backups run every night (or any other increment) and also.. auto delete any backups over (X) number of days old. I run a backup everynight, and delete backup files over 3 days. thats usually enough to recover.
..
and PS the previous post is correct. make sure you have more security than "sa"... only a few people should have "DROP TABLE" privilege.
October 20, 2003 at 4:55 am
before doing anything backup your MDB and LDF and any log files ...
are u doing any other kind of Backup with the Full Backup ??
Alamir Mohamed
Alamir Mohamed
Alamir_mohamed@yahoo.com
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply