Bruce Szabo


Technical Article

Kill Processes in a Database

This script kills all the processes using a given database.  It is useful for removing users from a database so it can be restored.To use this script change the server variable and the database variable at the top of the script.  Notifications are written to the windows application eventlog.Use this script at your own risk. […]

You rated this post out of 5. Change rating

2002-07-12

1,094 reads

Blogs

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...

Free PostgreSQL Performance Monitoring with pgNow

By

I’ve been putting together a new PostgreSQL session called “Performance Monitoring for the Absolute...

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