Technical Article

Verify that your backups are archived.

If you backup your databases to a disk file, you should make sure that these disk files are then being archived to tape. Without this, your ability to recover the database is compromised in the event of a disaster. This script will examine the "archive" flag on all of the backup files to make sure […]

You rated this post out of 5. Change rating

2006-01-22 (first published: )

297 reads

Blogs

The Mysterious Empty Table

By

It seems like no matter how long you work with a system beyond a...

Choosing to not drive the Tesla

By

I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...

Advice I Like: Transactions and Relationships

By

Life gets better as you replace transactions with relationships. – from Excellent Advice for...

Read the latest Blogs

Forums

Understanding Bit Manipulation Functions: BIT_COUNT, GET_BIT, and SET_BIT in SQL Server 2022

By Noman072

Comments posted to this topic are about the item Understanding Bit Manipulation Functions: BIT_COUNT,...

Mixed Backups

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Mixed Backups

Or condition in where clause works differently in MS SQL comparing with Sybase

By james_toronto

Hello, I ran below statements in MS SQL, and got error, but fine in...

Visit the forum

Question of the Day

Mixed Backups

I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).

BACKUP DATABASE [complex]
    FILE = N'thirdone'
 ,  FILE = N'thirdtwo'
 ,  FILEGROUP = N'second' 
 TO  DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak' 
 WITH NOFORMAT, NOINIT,  NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO

See possible answers