Viewing 15 posts - 31,711 through 31,725 (of 49,552 total)
Drop database does indeed delete the files. Not move to recycle bin. Delete.
You can try and use an undelete tool, see if it'll get the files back intact and, if...
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
July 21, 2010 at 11:45 am
HP Pavillion Wide-screen 15.4. It's an entertainment notebook, which for me means pretty good specs without too high a price. Runs SQL well, plays movies, runs games, just about anything...
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
July 21, 2010 at 11:04 am
You've told us just about everything except what the problem is. Care to elaborate?
What's slow? A specific query? Everything in one DB? Everything on an entire instance?
Has it always been...
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
July 21, 2010 at 10:56 am
Lynn Pettis (7/21/2010)
Looks to me that answers should actually go here, not in the other thread since the OP is using SQL Server 2005.
This was the third one I saw....
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
July 21, 2010 at 10:55 am
The only things that truncate the transaction log are log backups, explicit truncations (Backup log ... truncate only) and a switch to simple recovery. Neither full nor diff backups affect...
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
July 21, 2010 at 10:45 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic956270-1549-1.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
July 21, 2010 at 10:44 am
Bradley B (7/21/2010)
sorry syntax you are correct. I meant internal shrinking not external, which is truncating.
Truncating doesn't shrink anything, internal or external. All it does is mark any VLFs...
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
July 21, 2010 at 7:35 am
Bradley B (7/21/2010)
If simple model is not shrinking the log file for you then it means that part of the transaction is uncommitted or is still active.
Truncating !=...
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
July 21, 2010 at 7:08 am
Twinsoft SME (7/21/2010)
I always wondered why the newsletter puts articles that old in it?
Newsletter only shows forum posts with recent activity. kagemaru found this via the 'related content' (sidebar) in...
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
July 21, 2010 at 6:13 am
If the database is in full/bulk-logged recovery, a log backup marks the inactive portion of the log as reusable (sometimes referred to as truncating the log). It does not affect...
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
July 21, 2010 at 6:10 am
Please don't crosspost. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic956270-1549-1.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
July 21, 2010 at 6:06 am
It could result in the database not attaching. It could result in your database being marked inconsistent and unusable. Do not delete the transaction log unless you're willing to throw...
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
July 21, 2010 at 6:03 am
virgo (7/21/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
July 21, 2010 at 2:02 am
hxkresl (7/20/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
July 20, 2010 at 11:51 pm
If those questions are from the actual exam you wrote then, by reproducing them here you are in violation of the NDA that you accepted when you wrote the exam....
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
July 20, 2010 at 11:36 pm
Viewing 15 posts - 31,711 through 31,725 (of 49,552 total)