Hi John,

Sorry didn't get that. We've compared the restore times, 40 mins via the GUI and approx 10-15 mins when executed as code in the Agent job,

Andrew

Lynn, There were small delays between each stage as a DBA was not always on hand to kick off the next stage immediately, one of the main reasons we automated...

Hi John,

The biggest improvement was with the restore. The restore usually took about 40 minutes when performed manually (using the GUI) but is now taking about 15 mins when executed...

The process is running at the same time of day that we used to perform the backup and restore manually.

It's not a problem that it process completes faster but I'd...

Hello,

Maybe I asked the wrong question. I am trying to work out how permissions are assigned to each of SQL Server services in SQL Server 2008.

In SQL Server 2005 the...

Thank you Adam.

I think that's the way forward however I cannot guarantee that SQL Server 2008 will be available for me install as a separate instance. I'm really just trying...

Thanks for the response guys.

The supported upgrade paths for SQL Server 2008 at http://msdn.microsoft.com/en-us/library/ms143393.aspx show that SQL Server 2000 needs SP4 applied.

In an ideal world I'd like to apply SP4...