backslash is an escape character in C# strings so you should do something like the below.

= "myServer\\myInstance";

or

= @"myServer\myInstance";

Steve

[/url]

OK, for the benefit of anyone in our position in the future. The /passive successfully got our passive node up to the right SP. We suffered no downtime...

Thanks for the replies. This is agency data which enriches and corrects our dataset which is why we run over the top of all records each month.

The database is...

**replaced as wrong answer.

As SQL Server takes chunks of memory from the OS then if you see a valid process(es) using a 'normal' amount of Memory but is paging due to SQL Server...

While in Report Manager locally, setup a new role assignment, assuming you don't have an issue having anyone being a browser?

Just drop the port in the datasource definition that is pointed to by your report.

Its encrypted so you wont see it in a readable format. Assuming you can access the databases via SSMS when it fails over then it suggests it pointing at...

What does the data look like in SQL Server?

Check this out.

http://support.microsoft.com/kb/909678/en-gb

Lots of suggestions in there, I decided to run my export via subscription on a schedule. Takes a huge amount of time to generate but...

Hi,

Just done a quick test in my environment and a browser refresh just re-renders the page without calling the stored procedure again. Even if there are tweaks to IE...

Coozie (8/31/2010)

---

I agree. I'm more comfortable with using jobs to create backups and then back those up to tape because it just makes my life easier.

I've never did any...

Never used the product but we do have something that backs up our databases live, using a SQL...

You can't backup the database files unless you took SQL Server offline which defeats the point a bit and isnt the right answer by a long shot!

Take a backup via...

Coozie (8/31/2010)

---

Thanks All!!!

I see, so you can't do a backup on the cluster and access that backup from a remote server to restore it on that remote server; correct?

Rather, back...