Lets everybody stand back a little and take a good look at this.

Assume this is a production SQL 2005 DB and the recovery model is Full.

A dB get's data into...

My applogies, it was the "BACKUP LOG WITH TRUNCATE_ONLY or WITH NO_LOG". It appears in my log files, see below...

I run this just before I do the DBCC SHRINKFILE.

Anyone know...

Here's the code...

And yes I know I can create an SSIS package to do this. I just want to be able to script it so I may, in the future,...

I tried as you suggested...

DECLARE @DBNAME varchar(50)

DECLARE @MyCommand varchar(1000)

SET @DBNAME = '_RESTORERECOVER'

PRINT @DBNAME

SET @MyCommand = 'USE [' + @DBNAME + ']'

EXECUTE(@MyCommand)

But the DB never switched to the _RESTORERECOVER DB.

I ran...

Thanks everyone for the replies. I simply wrote a vbscript that prompted for credentials (not safe but for testing it works) to connect via SQL Native Client to my servers...

Move all your clustered resources in "Cluster Administrator" to the node you need to install it on and try it again.

Most importantly "Normalize" your DB when you are done. There will be a lot of redundant data as you merge your DB's.

Post your script. Is it a vbscript, TSQL, pearl, POSIX.....?

Have you ever just moved only th SQL resources in cluser admin? When I did this, the DTC service failed to start on the second node.

No worries. We ran into a problem with the first collation change at the column level. We had to remove it and put it back because other PK/FK and Constraints...

Did tou make colation change at the SQL Server level, DB level, Table level or Column? I would like to know because we made the change at the Column level...

If it's "deprecated" why the hell is there then? Why doesn't SQL allow case sensitivity to a column? Oracle does! Why can't SQL allow this feature with the default language...

I just re-read your original post. If your middleware folks say you do not need to pay for CAL's and you already purchased the SQL license, then you are fine....

CAL's are typically licenses required for connecting to a shared resource like a shared directory on your server like "\\yourserver\movies" and "\\yourserver\userdata" or shared printers. When it comes to SQL...

If the middleware app requires a SQL backend then did you install SQL? If you did install SQL then SQL has to be Licensed.

Or did the middleware app install an...