Take a Cold Backup without shutting down SQL.
Set the Autoclose database option to True and perform a cold backup of your data files without even shutting down the SQL Server Services.
2002-04-25
946 reads
Backup and restore
Kill all Connections
There are times you want to kill all the connections in a database. This would do that trick. This can be very useful when you replace a database regularly and some connections still exist so your automated restore fails. You can issue this command to kill all the connections before issuing a restore command.
2002-04-17
2,516 reads
Backup a database
This procedure when executed with the correct parameters, backs up a database in the specified directory pathUsage :exec USP_BACKUPDATABASE databasename, directory_path
2002-03-12
590 reads
Check for orphaned user or sid in syslogins
When rebuilding a server or setting up a backup or DR server the logins need to be added into master and synchronised with the user databases.Inevitably there are orphaned users is sysusers or the sid's do not match with syslogins.I use this stored procedure to check for a particular user when the user experiences a […]
2002-03-07
820 reads
Scripting user permissions
This Stored Procedure will display object level permissionsfor stated User or Role.Procedure output is ready to execute batch.Usage: Exec ScriptPermissions 'public'
2002-02-27
1,410 reads
Perform an action when a file exisits
Script to check whether a file exists with todays date and performs an action based on whether the file exisits or not. We use this to check whether backups have completed from another SQL Srver and if they have completed we restoe on a server used for management information
2002-01-09
2,056 reads
Transaction Log Can´t Clear
When the transaction log is full, sometimes the SQLServer 6.5 and 6.0 does not clear the transactions after dump command. This situation occours because not enough more page to record a end-point for transaction.
2002-01-06
267 reads
Generate Restore DB Scripts from prev backups v1.0
Using the the MSDB backup tables, will generate the basic disk RESTORE commands for a database. It will include the Full, differential and all associated log recovery commands for you. Run the stored proc in Query Analyser then copy/alter the output to recover your DB. Great if using EE is not your cup of tea. […]
2002-01-03
383 reads
List DB Backup Summary
Basic summary of all successful backups to date in descending date and ascending DB name order.
2002-01-03
553 reads
Fix - Orphaned User Connections
Run the '1'-first script.This stored procedures will easily script all the logins and passwords, which will then help you to transfer them to another SQL Server. Run the '2' - Second Script. This will fix the Orphane Connections. Run the '3' - Third Script. Fixing some Orphaned Users left after step 2. NOTE: Script below […]
2001-12-09
2,162 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers