Viewing 15 posts - 31,486 through 31,500 (of 49,552 total)
raamaakrishna (8/2/2010)
I know they get deleted, but what kind of command does sql server runs to delete those files?
It'll be an API call from SQL to the operating system requesting...
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
August 2, 2010 at 2:19 pm
Lynn Pettis (8/2/2010)
Probably. Why?
Think maybe someone's dropped a database and is hoping to recover 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
August 2, 2010 at 2:18 pm
CavyPrincess (8/2/2010)
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
August 2, 2010 at 2:12 pm
Also, take a look at this article. http://www.sqlservercentral.com/articles/65804/
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
August 2, 2010 at 2:09 pm
Restore from backup.
CheckDB with repair is a last resort for when you have no clean backups. It's not something you ever should need to do if you have a good...
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
August 2, 2010 at 2:09 pm
newbieuser (8/2/2010)
Is it possible to restore just the mdf file and will the management studio create a new ldf file while attaching the database?
Maybe, but not necessarily.
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
August 2, 2010 at 2:05 pm
The order columns are defined is irrelevant, it won't usually match the order they're stored in the page anyway. This was true on SQL 2000 as well, probably 7 too...
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
August 2, 2010 at 1:58 pm
WayneS (8/2/2010)
I would realistically charge (for something like this) a little less than what Gail is mentioning here... after all, she is a lot better than I! 😎
I was starting...
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
August 2, 2010 at 1:55 pm
Would you mind going back and editing that, and using the [ quote ] tag? It's hard to read where your replies are.
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
August 2, 2010 at 1:54 pm
Please note: year old thread.
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
August 2, 2010 at 10:26 am
No point trying to rebuild indexes or update stats on master or model. They have few-to-no user tables. Integrity checks they need, but not index rebuilds.
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
August 2, 2010 at 10:25 am
Severities below 11 are not errors. They're warnings.
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
August 2, 2010 at 9:45 am
mrpush (8/2/2010)
Why would the log file debachery have any implication on loggin into the LOCAL SQL server?
Because the login that you used had a default database set to one of...
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
August 2, 2010 at 9:39 am
Have you tried switching into bulk-logged recovery for the duration of the index rebuilds? Won't reduce the size of the log backups, should keep the log from growing. Also just...
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
August 2, 2010 at 8:39 am
Adiga (8/2/2010)
One more cross-post. I have responded to your question here
That link points to a thread on XML by a different poster.
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
August 2, 2010 at 7:57 am
Viewing 15 posts - 31,486 through 31,500 (of 49,552 total)