Viewing 15 posts - 46,081 through 46,095 (of 49,552 total)
Here's a step-by-step guide to recreating the MSDB database from the installation media.
http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/06/619304.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
June 25, 2008 at 1:57 am
Here's a partially cleaned up exec plan if anyone wants to take a look.
Is the exec plan correct in estimating that only 2 rows are returned?
I asee 2 immediate problems....
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 25, 2008 at 12:41 am
Thanks. I'll check those out.
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 24, 2008 at 11:57 pm
Do you have replication on either of these databases?
Is there any chance that someone has been messing with the files?
Very important, do you have a 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 24, 2008 at 11:53 pm
The client tool is management studio, I'm asking about the database engine you're trying to attach to. Thing is, that's a SQL 2000-specific error
Open a query to the SQL instance...
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 24, 2008 at 11:51 pm
Indexes? Any chance of the execution plan?
How many rows does the query return?
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 24, 2008 at 12:04 pm
Do you have a backup?
Can you look at the error log and see if there's any entry there that indicates why the database is in recovery-pending?
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 24, 2008 at 11:53 am
There are many warnings about running profiler on a production server, but those warnings are for the profiler GUI. The recommendation for tracing a production system is to use 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 24, 2008 at 11:48 am
Can you post the table structure, the indexes and the aprox row count please.
How long does it currently run?
If possible, can you get the exec plan (set showplan_all on), run...
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 24, 2008 at 11:36 am
So, the live database is missing some data and the backup is missing some data. Is that correct?
Is there any chance that someone deleted it?
Do you have a backup 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 24, 2008 at 11:01 am
Have you tried Redgate's SQL Data Compare?
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 24, 2008 at 7:41 am
Ah. I thought that might be the case. The corruption's in the system tables in MSDB and checkDB can't repair corruption in the system tables.
I know there's a way 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
June 24, 2008 at 7:38 am
Which one? Amazon lists well over 100 books on C# published by Wrox
Why do you recommend 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
June 24, 2008 at 7:30 am
MW (6/24/2008)
Would you mind if I ask you a few questions about thecredentials
Please post your questions in the certification forum.
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 24, 2008 at 7:26 am
Put the trace into a job on the prod server. It's not a heavy load providing you're writing to a drive that's separate from the data or log files.
The server-side...
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 24, 2008 at 7:22 am
Viewing 15 posts - 46,081 through 46,095 (of 49,552 total)