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

756 reads

Blogs

Daily Coping 18 Oct 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Azure Cosmos DB – HTAP using Azure Synapse Link

By

I haven’t done much blogging in the last 6 months. My last article was...

Azure Cosmos DB – HTAP using Synapse Analytics

By

I haven’t done much blogging in the last 6 months. My last article was...

Read the latest Blogs

Forums

Event log filling up with Sql error

By IT researcher

Windows event log filling up with ERROR 1 : "The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-]' running...

How to do Join

By patla4u

Hello, I am looking for output where EG_RequestID = 175998968 and Reissue from paymentID...

Connect to PostgreSQL as an External Data Source using PolyBase

By JerodJ

Comments posted to this topic are about the item Connect to PostgreSQL as an...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers