Backup and restore

Technical Article

Full, diff and tlog backups based on recovery mode

  • Script

    This a script which creates stored procedures that can be executed adhoc or set as sql agent jobs to check the recovery status and generate full, differential or transaction log backupf for each database if the database recovery status is set to full.  We have terabytes of data and set all production databases […]

You rated this post out of 5. Change rating

2003-06-06

935 reads

Technical Article

Delete old backup files

  • Script

This is one example of how you can make backups with a date stamp for the file name. You can then periodically remove the files that are older than a specified date by simply placing a few lines of code in a job step and calling the supplied sp and passing the date from which […]

You rated this post out of 5. Change rating

2003-04-25

771 reads

Technical Article

Restore DB from Disk File script

  • Script

This script was designed to restore a backup of a production database from disk file, handle multiple DB files, move the files to new location, with new database name that is customized for the date of the backup, create any missing logins, and fix any user accounts that are orphaned by differing SIDs from the […]

You rated this post out of 5. Change rating

2003-04-24

1,069 reads

Technical Article

Copy all jobs, job steps and job schedules

  • Script

This vbscript will generate the sql to recreate all the jobs running on a given SQL server. I wrote this because the last time we migrated a SQL server, I ended up re-creating all the jobs, steps and schedules by hand using the Enterprise Manager. It was the slowest, dullest and most error-prone part of […]

You rated this post out of 5. Change rating

2003-04-17

864 reads

Technical Article

Restore last backup to a different server/database

  • Script

Finds the last available backup for a specified database (local or remote server), then restores the backup onto an existing database on the local server.The script will kill all non-system processes in the destination database to allow the script to be scheduled at night regardless is anyone is still connected.The logical and physical names are […]

You rated this post out of 5. Change rating

2003-03-31

769 reads

Technical Article

Load Backup History from Backup File

  • Script

This script creates a stored proc to verify all backups in a media set and load their history into MSDB.  I use this frequently when I get backup files from clients and want to use Enterprise Manager's intelligent restore selection to quickly get the database restored on a test machine. 

You rated this post out of 5. Change rating

2003-03-11

305 reads

Technical Article

"RESTORE..... WITH MOVE" all databases on a server

  • Script

If, like me, you are constantly restoring/moving several databases between multiple environments (development to staging, production to training, etc.), you know how tedious it can get to use EM, or to manually type out all those RESTORE...WITH MOVE statements in QA.Even having a saved script isn't the ideal thing, as you still need to go […]

2 (1)

You rated this post out of 5. Change rating

2003-02-10

1,793 reads

Blogs

Advice I Like: Praise

By

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

By

I wanted to try out the new JSON index which is for the moment...

Prepping for Certification, Part 1 of ?

By

I thought it would be good to put my thoughts down on how to...

Read the latest Blogs

Forums

Learning a New Language

By Steve Jones - SSC Editor

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?

By stan

Hi, we have a few people who like to experiment on our prod sql...

Guidelines and Requirements

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Guidelines and Requirements

Visit the forum

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