Also, if adding the SPs to all databases on your instance, be sure to add them to the model database so you do not have to go through this process...

you didnt have a query window open using the Model database (query running or not) did you? This would stop the database being created.

run regular integrity checks 🙂

You would probably be best doing a google search for the information about different types of replication. To explain everything in detail would take somebody a long time to type.

Your right i do over complicate things.

I tried using the @job_name = @jobname before but to no avail when I was create an SP inside an SP, but with...

Already tried mate still didnt like it.

dbo.quote string info - http://www.sommarskog.se/dynamic_sql.html < search that page - ive attached this...

WHat i currently have is

Variables table -

Stored prod 1 - dbo.backup database - creates folder structure, backups up database, deletes old backups

stored proc 2 - input the database name...

It still doesnt like the initial + in the brackets.

Erland,

Even with the below, I get syntax errors it still doesnt run through. It doesn't like the dash

EXEC msdb.dbo.sp_add_job @job_name=N' + dbo.quotestring(@DatabasenameInput + '- backup Job') + ',

am...

But does your query show the ports that CAN be used? or the ports that people have used?

Nadrek (8/15/2013)

SQL Server Configuration manager, SQL Server Network Configuration, Protocols for <instance>, TCP/IP, Properties, at the bottom is IPAll - remove the TCP Dynamic Ports string and put 1433 in...

Erland.. in addition, I the reason i am doing it this way, is due to what you said about the time\date stamp in my origional plan.. it would have been...

Cheers guys.

Erland, your right. I should of stayed with your origional suggestion but the quotes were driving me nuts. However, Im going to persist.

How do I get aroudn the quotes...

That depends on your app and how it connects to the database? You should set up a DNS for it, then in a DR scenario you just need to switch...

I think this is to do with the "package protection level" when you are saving the package.