Nope I am having no luck here unfortunately, thanks anyway.

For whatever reason after I setup the ports, etc on both ends there is just no match happening for me.

The Ip address is ecternal.

The port number is the default 1433

Yes I have an sql server authentication account ready to go, thanks.

Yes there is a seperate IP on that machine

Thanks for the reply, it would be option 2, we have RDP on remote server but I am looking to get access to it locally without having to use RDP.

Have...

Hi guys,

Here is a useful script which can be used for an automated backup in sql express, it is much more simplistic I believe.

A question regarding this though, does anyone...

Thank you very much, yes we will be doing a great deal of monitoring for this along with a few days of tests before we consider going live with this...

I understand your concern especially given the fact I didnt really know how to create a SP but again we all have to start somewhere, this one in particular I...

Can you specify what you mean by SP please?

Ideally I would not like to identify the script exactly but I can give you a sample of the script with some...

Yes he gave great advice in fairness.

What I want to do so is run a script firstly at lets say 23.00 everyday to ensure that certain data is kept up...

Will I need to create a stored procedure for this script to run for a specific table as there is multiple tables under the instance I have created?

Or can I...

Thanks John, just wondering if you can explain in more depth by any chance please?