Viewing 15 posts - 40,666 through 40,680 (of 49,571 total)
winston Smith (3/3/2009)
seems it can be caused a lot by a database that was not cleanly shutdown.
That's not enough to send a DB suspect. SQL can recover a database...
March 3, 2009 at 6:00 am
Grant Fritchey (3/3/2009)
Also, do you get Management Studio (and all the other GUI tools) with SQL Server Express? I didn't think you did.
Not with it, but Management Studio Express is...
March 3, 2009 at 5:47 am
A detach commits (or rolls back) all transactions, writes all dirty data pages to disk, writes a mark in the log indicating a clean shutdown and then it removes the...
March 3, 2009 at 5:19 am
You can't execute anything against the mirror database unless it's brought online and if it's brought online you won't be able to implement database mirroring.
Drop the logins on the mirror...
March 3, 2009 at 5:02 am
Sakthivel Chidambaram (3/3/2009)
Option 2:Install SQL 2008 Client tools and connect to SQL 2005 and see whether intellisense works
It doesn't. 2008's intellisense works only to 2008 servers.
March 3, 2009 at 4:57 am
Just note those reports are based off the default trace which only keeps a certain amount of data (5 files of 20MB each). Data older is discarded. Also, as far...
March 3, 2009 at 4:57 am
Terminate as in kill their curretn session or terminate as in remove their access from the DB totally?
March 3, 2009 at 4:53 am
Insert the results of sp_errorlog into a table (temp table's fine) and then query that with a filter on the date.
March 3, 2009 at 4:53 am
Ewan Hampson (3/3/2009)
March 3, 2009 at 4:49 am
Paul Randal (3/2/2009)
March 2, 2009 at 1:37 pm
1) http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=120736
2) http://www.sqlservercentral.com/Forums/Topic666657-266-1.aspx
Why do people have no backups, no regular backups, no offsite backups, etc, etc.
March 2, 2009 at 1:32 pm
All three in the same filegroup?
Is the one you're trying to empty the first file in the DB? (the mdf?)
March 2, 2009 at 1:29 pm
Bob Hovious (3/2/2009)
Is this "feed a fish", "teach to fish", or ask "Why on earth do you want fish?"
"Why are you trying to fish with a shovel?"
I used to...
March 2, 2009 at 1:24 pm
pedro.ribeiro (3/2/2009)
I/O error (torn page) detected during read at offset 0000000000000000 in file 'C:\Documents and Settings\pribeirote.teste\Ambiente de trabalho\Mala\mala 2\Cópia de teste\teste.mdf'.
If I'm reading that correctly the database header page is...
March 2, 2009 at 1:05 pm
Viewing 15 posts - 40,666 through 40,680 (of 49,571 total)