Viewing 15 posts - 27,286 through 27,300 (of 49,552 total)
ALZDBA (3/18/2011)
Anyone in for SQL2005 mirroring and replication ?http://www.sqlservercentral.com/Forums/Topic1080627-291-1.aspx
( I don't have the combination )
No, but I suspect it has to do with log growth. Since the mirror's down, 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
March 18, 2011 at 1:03 pm
It's pretty much a golden rule with Microsoft products in general, install in chronological order. ie Office 2007 before office 2010 if you need both, SQL 2005 before SQL 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
March 18, 2011 at 12:41 pm
sqlservr.exe -f -T3608
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
March 18, 2011 at 12:38 pm
I strongly recommend that you don't pull exec plans using profiler unless the trace is filtered, short and run as a server-side trace. That's far from a lightweight trace, it...
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
March 18, 2011 at 11:39 am
Steve Jones - SSC Editor (3/18/2011)
The reason you might need logs from before the full is if your full is broken.
Yeah, but you don't need an extra right before 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
March 18, 2011 at 11:37 am
homebrew01 (3/18/2011)
In my scenario, you would need a t-log backup sometime after 3 pm, and before the next full backup.
Assuming all the backups are intact and restorable, why would...
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
March 18, 2011 at 10:51 am
Log backups. Starting with the one taken straight after the diff.
This may help a bit: http://sqlinthewild.co.za/index.php/2011/03/08/full-backups-the-log-chain-and-the-copy_only-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
March 18, 2011 at 10:50 am
Ninja's_RGR'us (3/18/2011)
He had me do 2 full daily and then hope we could take a tail tlog backup to do p.i.t. restore.
Tail log requires that the log file is intact....
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
March 18, 2011 at 9:13 am
amajor (3/18/2011)
Worked perfectly. All active statuses in log file have gone, DBCC Loginfo is clean, db file, log files and backups are back to normal.
Great. Now monitor it for...
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
March 18, 2011 at 9:04 am
Execution plan?
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
March 18, 2011 at 9:04 am
"The SAN can't possibly break" -> ROTFL. The worst database disaster I've seen was due to a faulty SAN controller.
Test the backupexec full with the log. I have not heard...
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
March 18, 2011 at 8:35 am
Rebuilding indexes only updates stats associated with those indexes. There are still column stats that may need to be updated.
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
March 18, 2011 at 8:32 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
March 18, 2011 at 8:18 am
If you're asking for dumps, do note that use of such is cheating. Dumps are actual questions taken from the exams in violation of the NDA. Using or distributing dumps...
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
March 18, 2011 at 4:43 am
LSN is a log sequence number, it's kinda the address/identifier for a log record.
What are you trying to do/find here?
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
March 18, 2011 at 3:26 am
Viewing 15 posts - 27,286 through 27,300 (of 49,552 total)