Viewing 15 posts - 35,326 through 35,340 (of 49,552 total)
The Dixie Flatline (12/12/2009)
Too rainy to play outside today, but we went to see "Invictus".Rugby players eat their dead.
I saw the preview for that. Brought back some memories. I still...
December 13, 2009 at 2:31 am
Look in cluster administrator. Make sure that the SQL instance is a cluster resource. Make sure that the possible owners for it are the correct nodes.
Is there someone there that...
December 12, 2009 at 12:54 pm
nbz_01 (12/12/2009)
could you guess where is the problem?
From your description, no.
Got anyone there that knows clustering?
What is DB2?
What's in the groups ClusterGroup & Group0
December 12, 2009 at 3:11 am
mahesh.vsp (12/12/2009)
Can you please list out those which does work in 2000 and 2005??????
Do the testing!
I don't remember every single command (though I'd imagine Books Online does <hint>). It's not...
December 12, 2009 at 2:45 am
Start cluster administrator (cluadmin) and make sure that the SQL resource group is there.
December 12, 2009 at 2:31 am
Why are you considering enabling traceflag 806? On whose advice with what reason? What do you think it does?
December 12, 2009 at 2:01 am
Connection string, only if the server or instance name changes.
As for everything else, you need to do some serious, thorough testing before you even consider upgrading the production server. There's...
December 12, 2009 at 1:57 am
Logins, along with their passwords, and all server-level permissions are stored in master. You can't fix orphaned users if you don't have the logins.
Linked servers are in master.
MSDB stores backup...
December 11, 2009 at 11:25 am
Sourav-657741 (12/11/2009)
(1) For the above case, what is the potential solution to retrive solution to minimise data loss?
As I said
If that doesn't work, then nothing will and the last...
December 11, 2009 at 10:11 am
jwa082276 (12/11/2009)
data and logs are split onto separte drives; tempdb on its own drive.
Separate physical drives or just partitions on the RAID array?
December 11, 2009 at 10:08 am
SQL is a server product. Typically it's running on a server and the client is elsewhere. To get a prompt for an input, you need a front end that has...
December 11, 2009 at 10:07 am
Why are you doing the log backup to what looks like a file with full DB backups in? That's just confusing.
Try this
BACKUP LOG AdventureWorks
TO DISK = 'Z:\SQLServerBackups\AdventureWorksTailLog.trn'
WITH NO_TRUNCATE;
From Books...
December 11, 2009 at 9:53 am
Ow. RAID 5.
How many spindles? How are the data files laid out? Which log and data files are on which physical disk(s)?
December 11, 2009 at 9:51 am
Please post queries, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Logical reads aren't the only measure of query performance. They are usually a reasonably good one, but there...
December 11, 2009 at 9:46 am
Viewing 15 posts - 35,326 through 35,340 (of 49,552 total)