Lori Brown

  • Interests: SQL Server, Running, Swimming, Biking

Blogs

Finding the Latest Backup Timestamps for Your Databases

By

Finding the Latest Backup Timestamps for Your Databases I wanted to find out the most...

Using SQL Elastic Pools

By

We use SQL elastic pools at work. I needed to learn more about their...

Webcast: How to Secure SQL Server – End to End Security

By

On April 16, 2024, I will be giving another webcast; this one will be...

Read the latest Blogs

Forums

SQL agent help

By rocky_498

Hi Guys, I have an SQL Agent job. It is called an SSIS Package...

Database Mirroring is Back in Azure SQL Database

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Database Mirroring is Back in...

Tracking Database Growth - Script Automation & Reporting

By EM2

Hello,   I found this script that helps me in populate a table with...

Visit the forum

Question of the Day

The Cloned Database Size

I have a small test sandbox database on an instance with default master, model, msdb, and tempdb settings. The database has these files:database file propertiesI now run this command:

DBCC CLONEDATABASE(sandbox, sandbox_clone);
GO
When I examine the database file properties, what do they show?

See possible answers