Viewing 15 posts - 29,941 through 29,955 (of 49,552 total)
george sibbald (10/15/2010)
sounds like someone truncated your database log.
If this is a SQL 2008 server (it's posted in the SQL 2008 forum), someone switched the DB to simple recovery and...
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
October 15, 2010 at 7:06 am
Master contains all the database-related info, all logins, server-level permissions, linked servers, startup procedures.
If you don't have a backup, what will happen if the DB is corrupt or drive fails?...
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
October 15, 2010 at 5:52 am
aspardeshi (10/15/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
October 15, 2010 at 4:31 am
Use sp_spaceused
As for unused databases, no easy way.
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
October 15, 2010 at 2:25 am
aspardeshi (10/15/2010)
Please let me know what is DRI.
Declarative Referential Integrity
I found a workaround though which can be helpful, can you disable the constraint of foreign key related to 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
October 15, 2010 at 2:19 am
No. Only user processes can be killed.
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
October 15, 2010 at 1:33 am
CirquedeSQLeil (10/14/2010)
That's quality entertainment
Yup.
Currently watching them test to see if a cup of soda can kill you through a windscreen if thrown while cars travelling at highway speed. Actually scary,...
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
October 14, 2010 at 3:07 pm
Craig Farrell (10/14/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
October 14, 2010 at 3:02 pm
But that won't work, because only an order by on the select statement guarantees order, not 'order' in a table, not order by on an insert.
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
October 14, 2010 at 3:01 pm
mattwilson247 (10/14/2010)
I see. He is saying to re-build the LDF in Emergency mode. I will look at his link and try it. Thanks.
Yup.
And just for reference, Paul...
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
October 14, 2010 at 2:27 pm
SKYBVI (10/14/2010)
@ gailJust to look good another table without an order by clause..
Not sure what you meant there...
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
October 14, 2010 at 2:25 pm
WayneS (10/14/2010)
Hate to bring this up, but does this mean that you had a better day at work today?
Wasn't at client today. Only there 3 days a week (more than...
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
October 14, 2010 at 1:57 pm
Look up SELECT INTO in the aforementioned Books Online.
Though, if you're doing that, ditch the Order By. An order by on an insert or select into in no way guarantees...
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
October 14, 2010 at 1:47 pm
WayneS (10/14/2010)
How'd you do that???
Fast typing. 🙂
Anyway, you posted a very nice link for it... I didn't have it handy (haven't added it to my clippings yet!)
You haven't added...
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
October 14, 2010 at 1:41 pm
This should do the job. Note that I've increased the size of the userID column and added a datedeleted. Doesn't help much if you know who deleted rows but not...
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
October 14, 2010 at 1:38 pm
Viewing 15 posts - 29,941 through 29,955 (of 49,552 total)