Viewing 15 posts - 43,396 through 43,410 (of 49,552 total)
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 31, 2008 at 2:44 pm
Ans sys.databases still shows the same value for the log reuse for that database?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 31, 2008 at 2:25 pm
What errors is that giving on SQL 2005? Or is it returning incorrect results?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 31, 2008 at 8:35 am
jmanly (10/31/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 31, 2008 at 8:30 am
😀
GOs break batches and hence variables declared before will be out of scope afterwards.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 31, 2008 at 8:05 am
And if you're not learning from books, mentors or others when you are the senior DBA then either you know everything (which is unlikely) or you think you know everything.
The...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 31, 2008 at 8:04 am
Garadin (10/31/2008)
Syntax issue.Use this instead:
select id, name, changedatefrom table1
where changedate > GETDATE()-5
Beware of the time portion of dates. That, if run now, would miss any entries with a time before...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 31, 2008 at 8:02 am
The where clause must be a condition that returns true or false. Your is not. changedate-5 is simply a value, it's not a condition. It will return a date 5...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 31, 2008 at 7:58 am
Viewing 15 posts - 43,396 through 43,410 (of 49,552 total)