That link is more for MSSQL 2000 which is a little different to 2005 onwards so I don't think that will help.

Cheers

Farren

Yes I sure did 🙂

As I say, this is something that I set up on a test environment very easily and am following the same procedure in live so am...

I definitely have the shared drives configured OK and have got this working no problem in our test environment.

I would assume to see a more obvious error if it was...

Sure.

Erm, all running on 2005, and I go through the whole process of adding the primary, secondary and monitor and then when I have done all that and click OK,...

Thanks Joe

At least I wasn't missing something obvious.

Regards

Farren

Thanks, I'll check out the link.

Regards

Farren

Just bumping this one to the top in case anyone can help me as I'm lost.

Regards

Farren

Wonderful, thank you very much.

I'll have a look at that.

I'm a bit concerned as it's a live box in the US and I don't want to break anything 🙂

Regards

Farren

Hi Old Hand 🙂

Sorry, I didn't make it clear. Yes, the actual server name is SOM-DB-ICCM but the entry in sys.sysservers is USDC-ICCMDBDEV, so when I try to configure log...

Hi

Well sadly I was using the GUI as I'm really new to SQL server.

So, I am now running the command instead..

DBCC SHRINKDATABASE (mailing, 10)

GO

I'll see if that does the trick....

Thanks people, that gives me plenty to be looking into.

Re REDGATE, do you mean place a support call or just post something on the REDGATE forum?

I inherited all this stuff...

Actually I just found this..

http://rusanu.com/2007/11/10/when-it-rains-it-pours/

I have forwarded it to the application development team.

Thanks for your help people, I think that gives me all the info I need.

Cheers

Farren

Ah, ok cool. I shall ask the user to create a file for me.

Many thanks

Farren