Viewing 15 posts - 14,821 through 14,835 (of 49,552 total)
Vedran Kesegic (1/12/2013)
But there is one more thing that checkpoint does to the log in regard of log truncation.Checkpoint is one of several prerequisites for log clearing.
Yes, I'm well...
January 13, 2013 at 1:09 am
From Books Online:
logmarkhistory
Contains one row for each marked transaction that has been committed. This table is stored in the msdb database.
January 12, 2013 at 2:24 pm
GilaMonster (1/12/2013)
Use T-SQL. I gave you the restore outline.
January 12, 2013 at 11:21 am
muthukkumaran Kaliyamoorthy (1/12/2013)
Have a look Truncating and shrinking the transaction log file[/url]Also take a look @ http://www.sqlserverblogforum.com/2011/06/sql-server-recovery-models-and-backup-types/
There's a bunch of errors in both of those, just beware (but that should...
January 12, 2013 at 11:18 am
As I said, in SQL 2000 incorrect page usage stats was acceptable, in 2005 and above it's considered an error.
Since you're upgrading from SQL 2000, you have gone from a...
January 12, 2013 at 10:03 am
Vedran Kesegic (1/12/2013)
January 12, 2013 at 9:57 am
Is the mark within the selected log backup? For that matter, have you selected a log backup to restore?
January 12, 2013 at 9:56 am
Just do what the messages tell you to. In SQL 2000 incorrect page usage stats was acceptable, in 2005 and above it's considered an error.
January 12, 2013 at 9:55 am
SQLSACT (1/12/2013)
Where do you draw the line between this, when does code become "bad code".
When testing shows that it performs badly.
Performance tuning is based on testing, not guesswork. Find...
January 12, 2013 at 8:46 am
Err... wild guess... simple recovery model?
No log backups?
January 12, 2013 at 8:43 am
jonathanforster (1/12/2013)
January 12, 2013 at 7:56 am
Nasreenm (1/12/2013)
Thanks. I think Microsoft should provide an official training kit if it doesn't want people using brain dumps...
Sorry, think that a lack of hand-holding training guides is a...
January 12, 2013 at 7:51 am
zi (1/12/2013)
I made a tran mark , and I cant find it in the GUI SSMS to restor the log at this pointWhat should I do
Use T-SQL. I gave you...
January 12, 2013 at 7:48 am
zi (1/12/2013)
The WITH MARK option only applies to the first BEGIN TRAN WITH MARK statement. The option...
January 12, 2013 at 6:03 am
SQLSACT (1/12/2013)
In your opinion, what's a better approach: Changing the T-SQL Code or adding indexes to accomodate the code ?
Yes.
Adding indexes is useless if the problem is in the code....
January 12, 2013 at 6:01 am
Viewing 15 posts - 14,821 through 14,835 (of 49,552 total)