Technical Article

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

757 reads

Blogs

Resources for Architecting Zero Downtime Deployments

By

I delivered my talk on Architecting Zero Downtime Deployments yesterday at VS Live Las...

Daily Coping 23 Mar 2023

By

Today’s coping tip is to focus your attention on the good things you take...

SQL Bits 2023 Recap

By

I had an amazing time adventuring to Wales with other members of the data...

Read the latest Blogs

Forums

Grouping the first letter in a string

By sathishkm

Hi All, I have the column of data in SQL Server. Here  I need...

Converting To/From User Friendly Trigesimal Geocodes

By Todd M. Owens

Comments posted to this topic are about the item Converting To/From User Friendly Trigesimal...

AG listener error

By roshanbi

Dear Support,   could you please advise why error below prevents me from adding...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Cloud Diagrams

See possible answers