The compatibility level can be changed back, if needed. When you...

Not quite true...SQL Server...

If you have purchased per processor licensing for 2008 R2 - you are already licensed on that system and can install multiple instances with no additional cost.

Double check your licensing...

Using cluster administrator - you select the resource group that you want to move, right-click on the group and select the option to move the group.

You should have at least...

As long as you are not bringing the DR system online, then all you need to restore is the log files. Which is what log shipping does for you.

The...

Sidenote: you really should not be running SQL Server using a domain admin account. That is going to potentially open you up to some serious security risks.

The recommendation is...

LutzM (3/29/2011)

---

You need to define the submissionbatch you want to return if there is more than one. You could either use MIN(),MAX(),SUM() or any other aggregation you like.

But then you'd...

With high safety mode - which is a two-phase commit, there would not be anything in the primary log files to recover. That is because nothing gets committed on...

I still do not understand why MS has set that as the default option - it is not the recommended method for backing up the system.

The recommended method is to...

What is the date '2011-3-1' supposed to represent? Is it March 1st or January 3rd?

SQL is going to interpret that date according to the date format for the server....

First, you can use OR in an IIf statement with no problem. I have done this several times, and used AND also with no issues.

Now, on to the issue...

Lowell (3/25/2011)

---

your if statement stuff would work, absolutely;

what i was implying, is you could possibly rebuild the synonym every time, something like this:

--Usage EXEC GetData 'SERVERNAME'

Create Procedure GetData(@WhichServer varchar(30))

AS

BEGIN...

No, you cannot use synonyms this way. For this to work, you need to use dynamic SQL instead.

If you try to recreate the synonym every time the procedure is...

Brandie Tarvin (3/24/2011)

---

Tara-1044200 (3/24/2011)

---

everything looks normal in the error logs except this message which i think is informational.

SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'Bound Trees'...

I have a 1.2TB database that I restore nightly to a report server. The backups are made with Litespeed and we compress to a bit less than 200GB.

Instead of...