Viewing 15 posts - 38,656 through 38,670 (of 49,552 total)
Circular logging is something that the windows event logs do. The SQL transaction log is not an event or error log. If you're in full recovery and are not managing...
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
June 5, 2009 at 9:17 am
If you're running against a test server, just clear the proc cache each time before you run it. Otherwise, if you want a recompile for a single query, use OPTION...
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
June 5, 2009 at 9:11 am
The errors that you've posted are because the RESTORE VERIFY ONLY can't find the file to verify. (Operating system error 2 is file not found)
What's the error that the backup...
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
June 5, 2009 at 5:43 am
sateesh.kamalakar (6/4/2009)
but still error i am getting in applying the schema name for the two tables.
What error?
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
June 5, 2009 at 12:21 am
WayneS (6/4/2009)
Paul, I do believe that you found what was going on.
Ok, I was assuming you meant it had changed sometime after the replication was set up.
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
June 4, 2009 at 10:54 pm
Mayank Khatri (6/4/2009)
Gila,Please look at this MSDN as u might have done many times earlier, u can SHRINK the file using TRUNCATE ONLY that would break the sequence
I see...
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
June 4, 2009 at 10:51 pm
TRACEY (6/4/2009)
The 12 i think i found on some thread what to check for
Yes, but the check is always for > 12, not <12
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
June 4, 2009 at 10:45 pm
What defines whether a database is active or not?
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
June 4, 2009 at 3:50 pm
WayneS (6/2/2009)
Is there anything going on in sql 2005 that would cause these default definitions to be changed? How else could all of these have been changed?
None that I've ever...
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
June 4, 2009 at 3:42 pm
Please read through this - Managing Transaction Logs[/url]
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
June 4, 2009 at 3:41 pm
Mayank Khatri (6/4/2009)
If u Truncate the log file using TRUNCATE ONLY(by either shriinking log or by either taking backup)
A shrink does not truncate the log.
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
June 4, 2009 at 3:38 pm
You might want to remove the call to shrink the database files as well. See - http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/
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
June 4, 2009 at 3:27 pm
Probably bad execution plan due to out of date stats and probably because DBREINDEX updates stats.
Try UPDATE STATISTICS next time, see if it helps.
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
June 4, 2009 at 9:07 am
Lynn Pettis (6/4/2009)
Here we go again with truncating and shrinking logs, especially when people don't understand what it is they are doing.
Do you understand what he's done? Cause I'm not...
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
June 4, 2009 at 8:54 am
Sorry, I don't understand what you've done or what your problem is. Can you explain more please?
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
June 4, 2009 at 8:51 am
Viewing 15 posts - 38,656 through 38,670 (of 49,552 total)