Hi,

Rebuilding a cluster because of a permissions error seems a bit drastic!

Just to be clear, how many clusters do you have / trying to build ?

You've mentioned 3 nodes and...

Might be worth trying to reinitialise the subscription, marking the option for 'Use a new snapshot', and tick the box to 'Generate a new snapshot now'

Cheers

Vultar

bobfirek (4/26/2012)

---

Vultar,

Have you converter from Polyserve to Windows 2008 R2 clusters yet? If so how did it go. Have you heard anything more about the end of life for Polyserve?...

Hi Matty,

We've just implemented a in-house written powershell script to run a CHECKDB against our environment from a central location and store the results in a db on a weekly...

As a work around, and providing you don't care about the TestDb you're trying to restore over, I would detach it, selecting the option to kill any connections before restoring...

Does the code in the job have error handling ? If it does, then it might be worth looking at how the errors are being handled / ignored.

Cheers

Vultar

From the development side I would start off with SELECT statements and move on from there. Once you've understood this, move onto INSERTS, UPDATES, DELETES & MERGES, before moving onto...

Good point.. I misread the original post! :blink:

vultar (1/18/2012)You will also need to stop the SQL agent if it's it still running.

There's no need to. I would not recommend this (or anyhing else) until the OP comes...

You will also need to stop the SQL agent if it's it still running.

Building a package in SSIS and running it in a SQL Job could be a good option for you.

Cheers

Callum

We've got a powershell script to collect this info.

I'd give Gails suggestion a go.. I didn't think...

Try DBCC SHRINKFILE against the data file if you feel you really need to.

Will the datafile grow again, therefore requiring another shrink ? Repetition of these actions will fragment your...

Superb, this gives me a good indication of the minimum time I need to measure over.

Thanks again for your help!