Viewing 15 posts - 40,651 through 40,665 (of 49,552 total)
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...
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
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.
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
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...
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
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?
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
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.
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
March 3, 2009 at 4:53 am
Ewan Hampson (3/3/2009)
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
March 3, 2009 at 4:49 am
Paul Randal (3/2/2009)
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
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.
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
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?)
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
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...
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
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...
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
March 2, 2009 at 1:05 pm
Steve Jones - Editor (3/2/2009)
Always restore with NORECOVERY and then once you're sure you're done, run the statement Gail has listed above.
Agreed. Much safer than putting the WITH RECOVERY flag...
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
March 2, 2009 at 12:58 pm
ElSuket (3/2/2009)
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
March 2, 2009 at 12:57 pm
There must be someone who has access to the server. The errorlog's just a text file. Without knowing why the DB's suspect, it's hard to offer a solution, and 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
March 2, 2009 at 9:41 am
Lynn Pettis (3/2/2009)
You gave the OP EXACTLY what he asked for in his post.
Nope. Barry's solution equates to IIf([x]="YEN","JPY",IIf([x]="EURO","EUR",NULL)) , ie
If X = 'Yen' then 'JPY' ELSE If X...
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
March 2, 2009 at 9:32 am
Viewing 15 posts - 40,651 through 40,665 (of 49,552 total)