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.

http://technet.microsoft.com/en-us/library/ms152531.aspx

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 script

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)

---

Yes.

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.

I have also just realised I pasted this in the wrong forum (should be in 2008)