Third Party Backup Tools – Redgate SQL Backup
To continue my little blog series on SQL Server backups, any series would not be complete without a look at...
2010-04-15
2,898 reads
To continue my little blog series on SQL Server backups, any series would not be complete without a look at...
2010-04-15
2,898 reads
Aaron Nelson (Blog|@SQLvariant) is hosting this months #TSQL2sDay with the theme of reporting. My post looks at some of things...
2010-04-13
664 reads
This process might not be granular enough for some but there is a nice simple way of creating a role...
2010-04-12
30,870 reads
I didn’t post my professional goals for the year on my blog at the start of this year, my blog...
2010-04-08
668 reads
For reason's beyond the scope of this post I needed to uninstall a 64 bit version of SQL server standard...
2010-04-06
2,445 reads
My last few posts have been backup orientated, I have a post on Full Backup, a post on Transaction Log...
2010-04-04
1,292 reads
One of my aims at the start of the year was to improve my Powershell and scripting skills. I run...
2010-04-01
1,127 reads
I recently posted a couple of scripts that backup all databases on your SQL Server instance to disk with a...
2010-03-31
1,271 reads
Today I discovered, from a post on the forums and a follow up dig into BOL that sp_change_users_login is to...
2010-03-30
5,799 reads
I have seen many forum posts asking how do you schedule backups for SQL Express databases and the answers always...
2010-03-29
1,697 reads
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
By alevyinroc
It seems like no matter how long you work with a system beyond a...
By Steve Jones
I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...
hi i imported a tabular model from production into vs 2022, changed the data...
Hi I have just installed again on win 11 sql server express 2022 with...
Comments posted to this topic are about the item Understanding Bit Manipulation Functions: BIT_COUNT,...
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 GOSee possible answers