Backup and restore

Technical Article

Restore Multiple Backup Logs

  • Script

Use This Script to restore Multiple Log backups from a Log Device file. The script will restore all the logs on the device and will leave the databse ready to use after finish. Before running this script you must verify if the database is in No recovery mode or read only state

5 (1)

You rated this post out of 5. Change rating

2005-05-09 (first published: )

436 reads

Technical Article

Synchronize the DB user SID with the Login SID

  • Script

If you attach a DB on an SQL Server different from the SQL Server where the DB was initially created, you will usually come up with a situation where a login will be a DB user however, you cannot see this through the login properties screen. That happens because the name of the login exists […]

You rated this post out of 5. Change rating

2005-04-21 (first published: )

1,410 reads

Technical Article

Verify that your backups are archived.

  • Script

If you backup your databases to a disk file, you should make sure that these disk files are then being archived to tape. Without this, your ability to recover the database is compromised in the event of a disaster. This script will examine the "archive" flag on all of the backup files to make sure […]

You rated this post out of 5. Change rating

2006-01-22 (first published: )

301 reads

Technical Article

DB to VSS V2

  • Script

This is an update/improved version of my script that I'm pleased to see is rated in the top 10! It will script off all of your objects in your database and if they differ from the scripted version in your VSS db, automatically check it in. If the object does not exist in VSS, this […]

You rated this post out of 5. Change rating

2006-03-30 (first published: )

742 reads

Technical Article

Backup All or one DTs Package(s)

  • Script

The script runs using vbscript code. It requires the user to enter parameters and run the script. The script uses both trusted and standard connection. The script also generate a log file each time it runs. Copy the code below and save it with .vbs extension.

You rated this post out of 5. Change rating

2005-02-21 (first published: )

291 reads

Technical Article

Large auto-job-creation script for adding backups

  • Script

This script creates a stored proc that was intended to run from a trigger on the master..sysdatabases for each database creation. Alas. It will create three jobs for each database you apply it to. First, it'll create a job to run a full backup each Sun, at 5am (see below). Those backups will be retained […]

You rated this post out of 5. Change rating

2004-12-16 (first published: )

376 reads

SQLServerCentral Article

Implementing a Flexible Backup Strategy

  • Article

SQL Server has a rock solid backup routine that works every time. However the schemes used to implement backups with maintenance plans, Enterprise Manager, etc., are not a smooth or as flexible as what most people require. Author Eli Lieba brings us his strategy and code for ensuring that each database is backed up how he needs it to be, whether a full or differential backup.

5 (1)

You rated this post out of 5. Change rating

2004-10-19

11,329 reads

Technical Article

Easy and Fast way to check Backup details

  • Script

Easy and Fast way to check Backup details. One line query to check backup status for all the databases. No need to go to each database or schedule job. Even you can use this query in customized application to get all the details on a single screen.

5 (1)

You rated this post out of 5. Change rating

2004-11-25 (first published: )

733 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