Brian R.A. Smith

Build restore scripts dynamically

This script will build restore scripts with the most recent full backup and all t-log backups since, for each user database in the SQL instance.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2.75 (4)

You rated this post out of 5. Change rating

2016-11-09 (first published: 2016-11-01)

1,344 reads

Next week is the 2024 PASS Data Community Summit in Seattle. I’ll be traveling...

bye-over – n. the sheepish casual vibe between two people who’ve shred an emotional...

I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...

Comments posted to this topic are about the item PASS Summit Time

I have a backup of full, differential and transaction log setup for our database....

Hello everyone, I hope you can help me. I have a table with measurement...

I have run this on SQL Server 2022 for the Sales database:

ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)

I then run this in the Sales database:

USE Sales
GO
CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFF

The dbo.Customer table is partitioned. How are statistics created?