oh yeah, and why can't they copy the SQL backups to tape for long term storage? Once they're written they're just a file like any other...

I'd definately have the EMC folks help you test the performance of bringing the db back into a restoring mode so that you could apply tlogs to check on performance.

Also,...

How are you handling the workflow? If you're using on success You'll never get an on success for a disabled step therefore it won't proceed because the on success...

ok, Thanks for the additional info. Yes this should be possible. It's more than likely the security settings that are causing you the heartache. These SAS programs,...

You can run a batch file on a remote server in a number of different ways.

a) use xp_cmdShell

b) Use windows scheduler

c) vbscript

You could even use the windows task scheduler...

Glad to hear it.

-Luke.

How did you try to "Run them on another computer". Did you try to attach them to the new SQL instance? Open SSMS right click databases choose attach...

It's possible. For me it all comes down to planning. I have an image of my laptop and backup my files to a networked drive. If something...

You should be able to use the Resultant Set of Policies function on both machines to find the differences. The log on locally policy may be causing issues if...

While yer testin, if you wouldn't mind running the original again with the dateadd(datediff)) bit instead of the cast(floor)) I'd be interested if that might not eliminate the difference between...

Thanks for the time it took to set up the test, and the additional info.

Good things to keep in mind.

-Luke.

More than likely, yes.

Most likely there should be a mdf and ldf for the db that you were developing. They're probably located in C:\Program Files\Microsoft SQL Server\MSSQL\Data and they would be named...

Gotta love those 3rd parties don't you... They'll bite you everytime.

Glad you were able to get back in.

-Luke.

What was in your sql express database? You might check your programs files\MS SQL Server directories for your databases, move them to a safe location on your disks, and...