Restore Server/Database users/roles
Restore server/database users and roles from another server when we are restoring databases to another server.
2012-04-12 (first published: 2007-10-23)
3,111 reads
Backup and restore
Restore 2000 DB to 2005
This script was designed to restore a backup of a SQL Server 2000 database from disk file to SQL Server 2005.Unfortunatelly the RESTORE will leave land mines for you to find the hard way, this script was updated to fix all that I have found:Change CONCAT_NULL_YIELDS_NULL ON, PAGE_VERIFY CHECKSUM, Compatibility level to 90, remove the […]
2007-09-14
4,522 reads
2011-06-01 (first published: 2007-09-02)
10,468 reads
Check Full Recovery DBs Have Tran Log Backups
A quick procedure to check which full recovery databases have not had a tran log backup in the given period (default is 7 days). This could mean that the recovery mode might need changing or the transaction log backup jobs need investigating.
2011-09-22 (first published: 2007-08-03)
1,708 reads
Shrink databases
This procedure is used to shrink the databases. Many times we use shrink option to shrink the databases for backup. and we do it N number of times, when we take the back of databses or make free space of drive.instructions:- Follwo the step.1. run script.2. And execute the statement, exec shrink_databasesI m new, if […]
2007-06-27
792 reads
Creating BCH Files for Veritas Direct to Tape
This script was written to solve a problem where we needed to dynamically create bch files for Veritas Backups direct to tape backups. We needed to parse the sysdatabases daily and create the bch files that veritas would use to backup each server and database. This SQL Script uses xp_cmdshell to call a windows shell […]
2007-10-02 (first published: 2007-06-18)
453 reads
Backup SQL Server Database with Move/Copy File
The following script performs log, differential or full backups of a single, or all databases on your SQL Server. It then copies or moves the file(s) over to a network share drive. It also removes old backups from both locations if needed. Don't forget to set the local drive path and network share for each […]
2007-09-14 (first published: 2007-05-16)
19,156 reads
Find The Database Recovery Model
A simple script to find the database recovery model. Cut & paste into Query Analyser
2007-05-17 (first published: 2007-05-08)
2,973 reads
Find DataBase Backup Modes
This is just a quick method to determine the backup mode of all databases on a server. No cursor involed.
2007-05-18 (first published: 2007-05-07)
425 reads
2007-04-27 (first published: 2007-04-03)
1,288 reads
Blogs
Advice I Like: Praise
By Steve Jones
Don’t reserve your kindest praise for a person until their eulogy. Tell them while...
How to Install SQL Server 2025 RC0 on an Azure VM
I wanted to try out the new JSON index which is for the moment...
Prepping for Certification, Part 1 of ?
By Brian Kelley
I thought it would be good to put my thoughts down on how to...
Forums
Learning a New Language
Comments posted to this topic are about the item Learning a New Language
is there a way to "detect" schema like changes on a server?
Hi, we have a few people who like to experiment on our prod sql...
Guidelines and Requirements
Comments posted to this topic are about the item Guidelines and Requirements
Question of the Day
Copying Production Schema
If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?
See possible answers