Cool.

And remember you can backup directly to a network share too, something like this...

BACKUP DATABASE MyDatabase to disk= '\\MyServer\MyShare\MyDumpFile.BAK'

...which can be very useful.

So yes, "Listen All" is set to "NO" and then the "Enabled" property for the individual IP address you want for the specific instance is set to "YES".

Then the same...

Cheers Mani, glad to hear you got that sorted ok.

Hi Mani,

Yes this is quite possible.

You just need to give the full UNC path to the dump file.

So for example if you are scripting the restore then it will look...

Would have thought you would be covered if you were to back up:-

1) Both databases.

2) Encryption key (although obviously this won't change unless you generate a new one).

3) Config files,...

For the problem of being able to check if the job is started, how about querying sp_job_status within MSDB.

Column "current_execution_status" tells you what the job is doing. The codes correspond...

I would say your two simplest options are either to create an SSRS report, or, if you don't have SSRS within your organisation then a batch file which calls SQLCMD.

Report...

Only reason I can think of for the Tracer Tokens tab not being visible is that the publication in question is not using transactional replication.

If it is a publication using...

Hi,

Not possible to force SQL Server to use a specific NIC, but possible to force it to use a specific IP address - so in your scenario this would achieve...

My question is what has SQL Agent got to do with someone being unable to connect to the database - and why would SQL Agent even be installed on 'the...

Hi Emily,

I think that every component of SQL Server requires a full SQL Server licence for every server that it is installed upon.

That is to say that if we were...

I think that the quickest and easiest way of migrating all your reports from one SSRS instance to another is to use this excellent (free) tool:-

http://www.sqldbatips.com/showarticle.asp?ID=62

I've seen other...

Hi John,

I've tended to use filesystem which has the advantages of:-

1) Not bloating MSDB if you have thousands of packages.

2) Ease of deployment of packages - DTSX files can simply...

Hi NJ,

A second clustered instance is definitely going to call for a second clustered disk resource, completely separate to the first disk used by the existing instance.

Hi Reo,

I would say your options are:-

1) Run the two Reporting Services servers as separate virtual machines on a single physical host.

2) Run two separate Reporting Services instances on the...