A mistake was made and "old" transaction logs (and old backups) were
deleted. It appears that a long living transaction was living in one of
those logs. Now the EP shows (no items). The DBs themselves are still
functioning OK, just the EP shell that's not working.
What's the proper resolution?
Thank you in advance,
FBCK
I want to know what to do to recover the deleted records on a specific table. Unfortunately, the dba was unable to activate Trace feature and I am not familiar in using the transaction logs to retrieve data.
please help. :confused:
Hi everyone
Is there any way to recover all deleted records.
By mistakes i deleted all records.
Please help me out
Waiting for reply.
Thanx in advance
Hello, everyone
If I don’t have any backup for SQL Server 2k on Win 2k, how to recover the deleted tables and database.
Thanks a lot.
ZYT
Hi gurus
Is it possible to recover deleted tables of the database ???
actually the senario is this ... i have delete the tables from the database and then import the same tables from the very old backup set. but unfortunatly the required data is missing in new imported tables ... now i want to recover the tables that i have deleted before the import operation.... please help me to overcome this problem.
thanks
chander
I have accidentally deleted a Database from SQL server 2005 instance. Is there any chance for me to recover the Database. If yes do let me know the method.
Thanks in advance
Mrinmoy
I want to learn that if my query deleted all data in the table by mistake, is it possible recovery and how?
View 1 Replies View RelatedOne of the developers accidently deleted a package from a SQL Server 2000 server. I restored the selected dts package record from an old msdb backup and restored it on the current msdb. Now when I open the error i receive an error
"No data for the specified package was retrieved from the specified server SQL Server"
How do i recover the delete package
hi
Can any body provide me any idea that how to recover database data if i have deleted that database
Bye......
One of my SQL Express databases was deleted by mistake through MS SQL Server Management Studio Express. It is not in the Recycle Bin and I have tried to use a tool such a Active@ Undelete to recover the file but it cannot find the deleted file.
I have a backup file *.bak in the ....MSSQLBackup folder I made using MS SQL Server Management Studio Express. When I try to use the restore database feature in SSMSE I get various errors.
Any Suggestions on how to recover the deleted file or
Any suggestions or documentation on using the restore feature in SSMSE?
Any help at all?
Thanks
George
It happened accidently that we deleted records from a table in SQL server 2005 DB. We never took a full backup of the DB till then. Is there any way that we can recover the deleted records. Logs files are still present. ( *mdf and *ldf ).
View 3 Replies View RelatedI accidentally deleted some useful data in my database. I have both .LDF and .MDF files for this database.
Is there a way to recover this database to a point of time?
Thx.
installation of their softwares? If there has NEVER been a backup ofthe Database (.mdf), Recovery Model Set to Full, and there has neverbeen a backup of the Log (.ldf) files?Using the trial software for both, this was unclear.Thank you for your time,bd
View 2 Replies View RelatedIf you know how to recover them I will be very pleased whith you.
Thank you.
Hi all
Any way to Recover truncated, deleted, or modified data . i will be appreciated for any help
I have deleted some data from some table. I dont have any backups and the database in simple recovery Mode. How to recover that data ...
View 15 Replies View RelatedGreetings,
I got severe data corruption issue today when I copied a SQLServer2000 database from our remote server to my local PC through enterprise manager. The new copy on my local PC did not have any records in the user tables, and when I looked at the remote server, the records gone either with only table skeletons and procedures there. The mdf file on the remote server is emptied at all, but that on my local PC still has 50MB. I think there are data in this file, but the ldf log was also emptied, but I cannot recover it -- I do not have backup and the ldf file was also emptied.
I ran checkdb, and it did not tell any error but show that all the user defines tables has zero records.
I wonder whether there is now any way to recover the data. They are important and I really dont want to lose them.
Thanks in advance!
Looking for a little assistance with a big problem.
I lost some data from a query that went wrong. I still have the logfile though, is there anyway of retrieving the data from the log file (.LDF) so that I can undo what someone did?
I located some 3rd party software but they are big bucks and the demos won't allow you to do it..
Thanks in advance,
Jay
My Client Accidently Deleted Somes Rows From Database Now. Now We are Struggling For Almost 2 Days To Get Them Backup. I Even Checked LDF File From Notepad It Have Those Rows But Not Formatted. (Some Similar Text From Some Column Which Got Deleted.)And The Database has no Backup which i Go to Task -> Restore...Server is Running on Sql Server 2008.
View 7 Replies View RelatedI wrong delete all contents of a table.
I was going to restore the full backup database but the file is corrupt.
I have:
The last 5 days backups of Transaction Log;
The actual Transaction Log;
Can you please give me any ideas of how to restore de transaction logs backups and/or uncommitted de deletion of all rows of the table.
Thanks,
Paulo
What is the best way to clear the transaction logs. My backup job each night is ending because it says it is running out of disk space and I need to clear up the transaction logs. Any help is appreciated. I see many different options (trucate option, auto shrink, etc.), just need some assistance tosome more specific best approaches. Thanks
View 3 Replies View RelatedIm having issues truncating my transaction logs. I have logs in excess of 40 gigs. All the info in the BOL is very vague. Any assistance would be apreciated.
Regards
SeTi Ni
When we backup the transaction log,will it truncate the log or it will grow from there?Truncate log on check point is desabled.
Thanks!
to take the transaction log back up regularly I should have truncate log on check point false. If I do so then how will I truncate the log.
regards,
Renu
I am trying to import records via bcp (about 1,500,000 records) and I keep running out of disk space. Is there any way to limit or do away with the transaction log (and still be able to import)?
View 2 Replies View Relatedhow do i decrease the transaction log example 500mb to 100mb, can you help me with the syntax pls!!
View 1 Replies View RelatedI need to move transaction logs to a different drive and am looking for a way to do it without detaching the db.
Can I create a second transaction log file for the DB and then delete the original log file?
What is the best way to do this for db's that are being replicated?
Thanks,
Ken Nicholson
I need to seperate my SMS data files and transaction logs onto two seperate drives. Can anyone assist me with this?
thanks...
HELP!!!!
When I look at the Database maintience plan history entry for backup I have a message that reads: "Backup can not be performed on this database. This sub task is ignored".
Have anyone come across this error before?? As part of the Maintenance plan some transaction log are being backup and some aren't instead they receive the message above.
Thanks
Lystra
Has anyone ever had the problem of the IT department not backing up thier transaction logs simply because they didnt find it necessary??
View 3 Replies View Relatedi have several sql servers doing maintenance plans and backing up the transaction logs to tape. unfortunately it seems that the server keeps adding the transaction logs to the same tape, without overwriting them. Nowadays a transaction log backup to disk takes 2 minutes but when done to tape it is taking up 1hr54minutes. What can i do so that the tape is automatically initialised without having to do it manually... Thanks
View 1 Replies View Relatedi was wondering if smeone could give me a breif over view how far back do these go
View 12 Replies View RelatedHI All,
Is this is a good idea or not?
If i attached my SQL Server to SAN only for DATA and LOG (Ldf) drives
through the FC. then we put *.bak and *.trn on to local disk RAID 1 drive?
Any performance isues?