xp_cmdshell or an Agent Job.

T-SQL works within the server. It cannot see anything outside of the SQL service without a shell like xp_cmdshell.

You would use the same commands that you...

There may be some resources for free, but almost all exam related books cost money. Authors work hard to build these books and you ought to pay them for their...

Well it's 9:56pm, Wed night, and I'm finally getting to this, after a busy day. I did get time off to run, run the kids around, karate, so it hasn't...

My pleasure. I don't like to give the whole answer until you've had a chance to try it, but if you get stuck, post what you've got and we'll help...

No, no issue in general, but if you have code in your trigger that is v7 specific, it might be an issue.

Moved to SQL 2000. Please post in the appropriate...

I had to read it 3 or 4 times to make sure I wasn't missing something. Is the logic for estimation really that hard?

Calculate the 2nd Friday in T-SQL. It's not a hard algorithm, but you need to work through the possible range of days and check the date.

So if you can do...

it's a time and bandwidth issue.

If it takes 10 hours to copy, the secondary is then "backup time" + 10 hours + restore time = time behind primary when you...

I've got a better one.

Made me laugh

I believe that CALs need to be upgraded along with the server.

You'd be better off doing this in Powershell or VBScript and calling the script from T-SQL if you need to.

Really? You have 15GB in 5 days. Can't you do the estimate for a year?

15GB * (365/5) = xxGB

Why a new instance? You'll be really juggling memory between them. Why not add a database for the new app?

Sounds like Veritas won't work on that version. What version of SQL do you have, and have you contacted Veritas? This isn't a SQL Server error, it's a Veritas error.

What does the job do?

You could write queries (if datepart(...)) that execute depending on the day of the month. Schedule the job for every day, only run it when...