Restore last backup to a different server/database

Finds the last available backup for a specified database (local or remote server), then restores the backup onto an existing database on the local server.The script will kill all non-system processes in the destination database to allow the script to be scheduled at night regardless is anyone is still connected.The logical and physical names are […]

2003-03-31

749 reads

Blogs

Extended Events Misperceptions: Profiler is Easier

By

I know, I know, I’m on #teamexevents so I think that Extended Events can...

I’m Speaking at #SQLSatSpokane

By

I am super excited to announce that I have been selected to speak at...

Common commands and tasks to make dealing with Windows Core easier.

By

I don’t know how many of you are working with Windows Core these days...

Read the latest Blogs

Forums

Move Data from SQL Server to Azure Blob Storage with Incremental Changes – Part 2

By Ginger Keys Daniel

Comments posted to this topic are about the item Move Data from SQL Server...

Knowing What You Don’t Know

By Grant Fritchey

Comments posted to this topic are about the item Knowing What You Don’t Know

Automate Import of LIBOR Rates

By Phil Parkin

Does anyone have any recommendations for sites which publish the daily LIBOR rates in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers