Lynn Pettis (6/7/2012)

---

There is also the other part of Disaster Recovery, how much is the company willing to spend, how much are they willing to lose (data wise), how quickly...

OPC.Three:

You are correct that clustering can be used. And I said clustering will ensure hardware availability, but its not 100% DR, thats why I said clustering alone can not be...

SQLCrazyCertified (6/7/2012)

---

opc.three

"If truly looking for DR then you want to look into Log Shipping, Mirroring or Clustering."

Hi opc.three, I just want to make sure something.....Is it 100% right...

SQLCrazyCertified (6/7/2012)

---

jitendra.padhiyar (6/6/2012)

---

Hello Guys,

I setup transactional replication and come to konw that the table with primary key is only accepted for Transactional replication.

I dont konw why.. Can anyone help...

opc.three (6/6/2012)

---

It provides a way for the the replication engine to identify a row unambiguously. Unlike unique keys, primary keys do not allow NULLs. Why do you have tables with...

Is CDC a new feature of SQL server 2008 be useful for such a capture ? Or change tracking ?

It seems to be index error on any specific hint object. Not sure. Provide much information to research on it..

Thanks a lot for the nice explanation!

One more question... Is undo file is like Checkpoint ?

Because according to my knowledge checkpoint also very usefull for database recovery, as it has...

opc.three (5/15/2012)

---

This is normal. When the initial restore was done it was done WITH NORECOVERY. Another option is to restore the database WITH STANDBY, but you have to provide an...

Yes, Iam trying to setup sql server cluster on my virtual test machines which has windows server 2008 Standard(evalution version).

And as you said windows cluster must to install sql...

Thanks a lot.

For testing purpose I have Windows server 2008 Standard version too on my virtual machine with SP1. And I think it also does not support clustering. Bcos when...

I tried to create new cluster using windows cluster wizard, but during analysing it gives an error says that you dont have correct version of Windows server.

I have Windows server...

Okay, so even

use msdb

SELECT backup_size/compressed_backup_size FROM backupset

Or

use msdb

SELECT backup_size/compressed_backup_size FROM dbo.backupset

are same as

use msdb

SELECT backup_size/compressed_backup_size FROM msdb..backupset

Am I correct ?

As GilaMonster suggested use the Convert function to convert date and time from string or reverse too, Below is an example

Select CONVERT(VARCHAR(19),GETDATE())

Result will be your sytems date and time:

Apr 26...

Yes, the space was missing in between collate definatino and primary key.

It should be like below :

create table #shortlist (spid varchar(12) COLLATE SQL_Latin1_General_CP1_CI_AS primary key);