Hi, is this a 32 bit or 64 bit server?

True you can use a UNC path in a scripted backup \ restore as per the example given, but you can also use UNC paths within Enterprise Manager or Management...

What I was getting at, is that sometimes the account lockout in 2005 seems to be a bit buggy.

I tend to see that if an account becomes locked out, just...

Hmm try this.

Next time the account is locked out, open the login properties and uncheck "Enforce password policy".

Then "ok" that. Then go back into the login properties and uncheck "Login...

I believe that your thinking with a holiday dates table is spot on Joshua.

Your job could simply determine if today's date is in the table, and if not, could then...

Ah well if you have existing applications already coded to access this second SSRS instance then yes I see your point about getting it working and leaving both instances running...

Have not tried myself to mirror from 32 bit to 64 bit, but I'm sure this must be possible.

The process of database mirroring takes place at such a high level...

Hi, not exactly an answer to your question, but I think you should give some thought to what you are trying to achieve with this architecture (2 instances of SSRS...

This has become an interesting secondary debate worthy of a separate discussion thread.

Should one follow directives from above, even when those directives at best contradict best practice, and at worst...

Thank you for the eloquent explanation Jonathan, that's exactly what I was trying to get at.

I recommend:-

http://www.amazon.co.uk/Server-Database-Administration-70-431-70-443/dp/0071496092/ref=sr_1_2?ie=UTF8&s=books&qid=1242557200&sr=8-2

How about this one:-

http://opendbiff.codeplex.com/

What collation are you using?

If you are using a CS (Case Sensitive) collation then you will have to refer to the object using exactly the same case as it appears...

Hi Nikola,

Yes actually the DB upgrade has gone very smoothly and it appears at first glance that all the reports are working.

I'm a little concerned with the speed of the...

Both have their merits.

If you do opt for A-A though you should configure SQL Server on each instance to only use a maximum of half the available memory (minus whatever...