Viewing 15 posts - 43,411 through 43,425 (of 49,571 total)
clive (10/31/2008)
What is the preferred option, with(nolock) or with(readpast).
Depends. Do you want to read dirty data or skip locked rows entirely. Better option would be to use neither and make...
November 1, 2008 at 2:45 am
Suspended indicates that the query is waiting for a resource. It may be a lock, it may be a latch, it may be for an IO to complete, it may...
November 1, 2008 at 2:45 am
liam.bell (10/31/2008)
And this will ultimately remove all transactions from the log file? To which I then have to perform a full database backup?
No. Shrink file will just change the size...
November 1, 2008 at 2:35 am
Then set the DB to simple. No point in full if there are no tran log backups
November 1, 2008 at 2:33 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic595287-146-1.aspx
October 31, 2008 at 2:44 pm
Ans sys.databases still shows the same value for the log reuse for that database?
October 31, 2008 at 2:25 pm
What errors is that giving on SQL 2005? Or is it returning incorrect results?
October 31, 2008 at 2:13 pm
See today's headline article. (http://www.sqlservercentral.com/articles/64582/)
What's acceptable data loss for that system? A full day?
October 31, 2008 at 2:05 pm
Then you've got an open transaction somewhere. That will prevent log reuse as logs can only be truncated to the beginning of the oldest open transaction.
What does DBCC OPENTRAN...
October 31, 2008 at 2:02 pm
Check the value of log_reuse_wait_desc in the sys.databases view. That will say why the space in the tran log is not been released. If it's 'Backup log' or similar then...
October 31, 2008 at 1:04 pm
xyzt (10/31/2008)
I'm fairly sure there is a better way.
Backup the tran log more often. It's not just about risk, it's about how big you want the log to...
October 31, 2008 at 11:13 am
Rob Symonds (10/31/2008)
Great article. I find myself struggling to explain these concepts to people on a weekly basis. You've put everything very clearly.
Thanks. I mostly wrote it because I got...
October 31, 2008 at 11:08 am
avi27 (10/31/2008)
GilaMonster,Thanks a lot for the tip. I was getting the same error and there was this job which was truncating the logs after the full backup
Thanks a lot
You should...
October 31, 2008 at 8:37 am
It's near impossible to say without knowing a lot more about your environment, your setup, the databases you have, the activity on them, the hardware and a fair bit more.
Is...
October 31, 2008 at 8:35 am
jmanly (10/31/2008)
October 31, 2008 at 8:30 am
Viewing 15 posts - 43,411 through 43,425 (of 49,571 total)