Sorry to bug you again..

BOL and all documentation says that Log shipping and Mirroring is available in SQL Server 2008 R2 Standard Edition.

But for me Mirroring and Log shipping are...

To be specific, I'm just in analyzing the best practices to refresh the data using SQL Server 2008 .

Because now we have the databases in ORACLE and we refresh...

How about Import/Export?

Can we use Import/Export to do data refresh from Production to Dev/QA?

In what scenarios, we use Import/Export?

I want to use Backup/Restore method for the first time and then I want to refresh the data only from Production database. So in this case which method is...

Hi ,

Again, I have installed SQL Server R2 Standard Edition x64 on new Windows 2003 R2 x64 and then created a Test database.

When I click the properties of the Test...

I got the same issue and when I tried to install using Add node operation again, set up did not find the instance in drop down to remove it. So...

SQL 2008R2 should install .NET3.5 if it is not present, as it is mandatory, so very odd that it is not appearing in your control panel, have a look in...

Sorry..Now I have attached the screen shot.

The database is in FULL recovery model

Here are the Edition details:

select @@version

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)

Apr 2 2010...

Unless it's causing an issue, I wouldn't worry about it. As far as I know it's just a label. I checked a few of my clusters and they all show...

Hi Derric,

I'm also allowed the SQL Server set up to create the Failover Group. But still the Resource Type shows as Unknown:hehe:

Please advice

Here is the solution:

Extract the SP1 files to a temporary folder and then install SP1 from there.

Thanks

Absolutely, the warning saying that you need to configure SQL Server 2008 on the added node.

So you are good to go:-)

The node was added successfully, but the 'SQL Server' resource type could not be installed on it. Unable to find 'sqsrvres.dll' on any of the cluster nodes

Question:

Can we ignore and...

NO, SQL BINN...

Only one job is failed. Because that is the only job running at that time and there are NO other jobs running

and all settings are fine. Thanks