More actions. My first backup created a. I thought this was reasonable as my database was created from an Access. I then added approx 1 years worth of data test data and did another backup. I then proceeded to delete the contents of one table about records. Add a comment. Active Oldest Votes. TransactionID, F4. MainSequence OR F5. StartTime EDIT I made some changes to the query, since one of the test databases I used is case-sensitive and it was losing some records.
That is awesome. I'll run this asap on my server s — edosoft. The first query indeed returns the start time of the restores, the second query returns nothing, maybe due to a join. I'm investigating The only thing that comes to mind is if the database IDs weren't matching because they were null -- hopefully my edits will work for you. Thanks again. To compensate for this, you should ideally get two rows per restore, one for the start of the restore, and one for the end of the restore.
The StartTime of the second action should actually be the considered the end time of the restore process. If you don't like the two-row result, it should be possible to take my query and tweak it so that it only returns one row, using the StartTime of the first event as the true StartTime, and the StartTime of the second event as the aliased EndTime, if that makes sense.
This worked perfectly!!! A backup was taking longer than seven hours. Saved me from rebooting out of what I thought was a hung server. I would like to thank you for this very good information. Most of the databases that they use are very small but occasionally they will ask for one of our larger production databases. The examples that you have presented will help greatly in the process.
Once again, thank you for your generous contribution. How to monitor backup and restore progress in SQL Server. Related Articles. Backup to multiple files for faster and smaller SQL Server files. Simple script to backup all SQL Server databases.
Using passwords with SQL Server database backup files. Changing the default SQL Server backup folder. Script to retrieve SQL Server database backup history and no backups. How to find out how long a SQL Server backup took. Script to obtain most recent SQL Server backup information for all databases. Popular Articles. Rolling up multiple rows into a single row and column for SQL Server data.
How to tell what SQL Server versions you are running. Resolving could not open a connection to SQL Server errors. Ways to compare and find differences for SQL Server tables and data. Searching and finding a string value in all columns in a SQL Server table. View all my tips. Back To Top Why do you have to restore the database? Was there some major error?
I truncated a table, then have to get it back from backup. Now I have the complete backup restored, but when I tried to restore the tlogs, it said I did not specify norevocery. I did not see that option when I got there from tools, restore, The second option in the recovery completion state section does this. Also, if you had the disk space, you might have been better off restoring the database backup to a new database, and then copying over the data from the table you truncated.
That way, you might have been able to leave your database online. Somehow I cannot map to it. You won't find a lot of patience for shyness with Query Analyzer a. I told my co-workers that I am going to buy them a lunch. I will try Tara's code in QA as soon as the complete backup is restore.
During the process of restoring the tlog, the complete backup went away. What a day! Hommer Aged Yak Warrior Posts Posted - : What did you mean by "not to use the database as current"? I'd appriciated you give me a little more details.
0コメント