cdye (12/11/2014)

---

I am hoping to get some guidance on the best approach for a read only copy of a database that is ~ 1TB. The primary database is fed...

one will insert rows to an already allocated table and one will have to create the table and employ all the I\O processes around the page allocations, as well as...

can you post some of the errors

no problem, thanks for posting back

Adam Bean (12/11/2014)

---

After some more digging and testing, it would seem that a SELECT INTO does indeed lock some of the system tables.

We're now starting to dissect performance between SELECT...

are these all on the same servers?

If node1 was the only node...

Minaz Amin (12/11/2014)

---

Steps taken so far:

--Empty files started

DBCC ShrinkFile(YEAR2015_FG,EmptyFile);

GO

--Removing files

Alter DATABASE ETL_MART REMOVE FILEGROUP YEAR2015_FG;

GO

-- Remove parition scheme depednecy

ALTER PARTITION SCHEME Yearly_Partition_Schemenew NEXT USED YEAR2015_FG

--Removing files group

Alter DATABASE ETL_MART...

it's no good complaining about network issues when your validation report is full of network configuration errors. You'll need to get these sorted first and ensure the report is clean...

quackhandle1975 (12/10/2014)

---

I see what your script is doing, have checked the path and ACL (sql service account has full control) but still would not work. I have moved the...

build yourself a virtual test system on your 8.1 machine 😉

easy to test, but, affirm. The raiserror will be passed to the job step and fail, if this step is told to quit on failure the job will terminate

OS error 5 while attempting to open or create the physical file 'E:\MSSQL\Templog\templog.ldf' is pretty clear. Double check the path and ACLs on the folder and file level

What does this...

lsalih (12/10/2014)

---

As I stated, node 2 is passive. I understand you can just right click on the instance and tell it to move to second node.

The goal is to...

just move the DEV group to node 2