2020-08-24
594 reads
Rebuilding system databases
Recreating Databases from Scratch with SQL Change Automation
Phil Factor starts with the basics how to rebuild a set of development database from scratch, using SQL Change Automation, and then demonstrates how to check for any active sessions before rebuilding, import test data using BCP, and secure passwords if connecting to the target with SQL Server credentials.
2019-10-29
Disaster Recovery: Rebuild system databases on SQL Server 2008 cluster
In this article we will see how to rebuild system databases in SQL Server 2008 cluster that is failed to restart.
2012-03-12
6,791 reads
Blogs
Playing with the Data API Builder
By Steve Jones
I published an article today on the Data API Builder, which is a way...
A New Word: Dolonia
By Steve Jones
dolonia – n. a state of unease prompted by people who seem to like...
Cloudbrew 2024 – Slides
You can find the slides for the session Building the €100 data warehouse with...
Forums
Understanding allowed topics for testing
Hi, I am a first time writer looking to author some content here. I...
Do As I Say, Not As I Do
Comments posted to this topic are about the item Do As I Say, Not...
Filter a SQL Server Audit with a predicate
Hi Gents, Silly question, but it's been a long time since I've done this....
Question of the Day
The New Log File
I have a detached database from SQL Server 2019, called TDE_Primer. This database had a 100MB data file and a 73MB log file. The log file was lost, so I need to run this code:
USE [master] GO CREATE DATABASE [TDE_Primer] ON ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\TDE_Primer.mdf' ) FOR ATTACH_REBUILD_LOG GOHow big is the new log file? See possible answers