Restore the latest database backup automatically and xp_dirtree
Posted in Programming, SQL Server on December 29th, 2008 No Comments »
I was asked to write a SQL server job to restore nightly a database running on a server onto another server. The database on the original
server was backed-up nightly by a database maintenance plan. So the job I was going to write was to find the latest backup on the original server, copy it […]
