Viewing 15 posts - 32,491 through 32,505 (of 49,552 total)
Some DMVs can only be reset by restarting the instance. Some are partially or fully cleared by restarting the database (offline/online, close/open, restore). Depends on the DMV.
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 11, 2010 at 10:46 am
Take the DB into single user mode and run checkDB with the repair_rebuild 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 11, 2010 at 9:10 am
beejug1983 (6/11/2010)
Command run successfully, do I need to restore full backup then all log backups ?
Yes, restore the full backup from thursday WITH NORECOVERY, then restore all log backups (I...
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 11, 2010 at 8:52 am
Then leave the memory at 12GB. Maybe drop to 11 if you're seeing evidence of OS-level memory pressure on the SQL server. If the database is the source of 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
June 11, 2010 at 8:40 am
Maybe, as long as he's completely sure that there was no truncation. (by him or anyone else or in a scheduled job)
Backup log <database name> to disk='<location for log 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 11, 2010 at 8:38 am
May I suggest that you start with an introductory T-SQL book rather. T-SQL Fundamentals (Itzik Ben-Gan) is a good option. worry about things like Reporting Services when you know how...
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 11, 2010 at 8:17 am
CirquedeSQLeil (6/11/2010)
Lynn Pettis (6/11/2010)
Some people really need to RTFM, or in this case, BOL.Yup - or at least finish reading that book from which the example was taken.
I hope that...
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 11, 2010 at 8:16 am
Oops.
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 11, 2010 at 8:09 am
Are you running the web front end and the SQL database on the same server? If so, that's a really bad way of running sharepoint in anything more than a...
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 11, 2010 at 8:08 am
Just underneath the 'My Account' link there's another link 'Control Panel' That'll take you to a page that has links for all your posts. Or you can click on 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
June 11, 2010 at 8:01 am
There is no chance of recovering anything. By truncating the log you discarded log records and told SQL that you were not interested in retaining log records any further. Additionally,...
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 11, 2010 at 7:58 am
Does the stp_deliverystatus stored proc take two parameters? If not, you can't just pass two parameters to it and expect that it'll work.
I strongly suggest at this point that you...
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 11, 2010 at 7:47 am
Are you seeing signs of memory pressure from the OS?
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 11, 2010 at 7:44 am
If the log was manually truncated since the last full backup, then there is no way to recover anything from the log as the log chain has been broken by...
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 11, 2010 at 7:43 am
Full recovery and no log backups?
Was the log getting manually truncated? (backup log .. truncate only)?
Is the database still attached to SQL? (I know the mdf is missing). 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
June 11, 2010 at 6:57 am
Viewing 15 posts - 32,491 through 32,505 (of 49,552 total)