Lennart Gerdvall

Import databases using backups

Import database from source server using full and transaction log backups as recorded in msdb. Use it to import one or more databases to your development environment, to test your backups regularly or to move databases to a new server. Works on SQL 7 and SQL 2000 with native and/or LiteSpeed full backups and native […]

2007-06-06 (first published: )

645 reads

Rebuild and Reorganize Indexes in SQL 2005

This SP rebuilds and reorganizes all indexes in the specified database or all databases. You can run code or generate code. Database will be set in bulk logged mode during processing and set back to normal when finished.Different SQL Editions are handled. LOB indexes, row and page locking options, number of processors, concurrent users and […]

5 (10)

2007-01-30 (first published: )

6,853 reads

Import databases using backups v 2

Import database from source server using full and transaction log backups as recorded in msdb. Use it to import one or more databases to your development environment, to test your backups regularly or to move databases to a new server. To move to a new server, take a transaction log backup and put all in […]

2005-07-04 (first published: )

203 reads

Blogs

Restoring Backups from Azure Blob with dbatools

By

Recently I needed to write a PowerShell script that could build a backup set...

Good to see you at Houston Tech Fest 2019!

By

It was awesome to see a great crowd at the triumphant return of Houston...

Using kubectl logs to read the SQL Server Error Log in Kubernetes

By

When working with SQL Server running containers the Error Log is written to standard...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Trying to create Nested SUM OVER Function for backwards running total.

By RocksteadyDev

Here is sample code from my running total, now I need to reverse it...

Copy or Move Shapshot Reports

By les.61

Hi We have snapshots on an old report that we would like to move...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The typo

See possible answers