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 […]

You rated this post out of 5. Change rating

2003-03-31

760 reads

Blogs

Creating an Empty Repo in GitHub–#SQLNewBlogger

By

I saw someone struggling with getting started with a Visual Studio project and Azure...

Product Review: DataVeil

By

If you’re looking at data masking tools, I recently was able to review the...

The Last Price Bump for the Data Community Summit

By

This week the cost of the PASS Data Community Summit jumps up to full...

Read the latest Blogs

Forums

👨ᐉ‍🦱+91-8890083807👨‍ᐉ🦱Engagement Todne Ka Wazifa - Sagai Todne Ka Wazifa

By duahelpme

Don't Waste Time Call For Immediate Solution WORLD FAMOUS ASTROLOGER MOLANA NAWAB KHAN, GOLD...

How to Setup Backups and Restore planning in SQL Server Availability Groups?

By BK

I need some help regarding How to Setup Backups and Restore planning in SQL...

Partition Large Tables needed

By sqlguy80

Hello Gurus, I have  a requirement and need to implement the solution quickly. SQL...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers