Lennart Gerdvall

  • Interests: Boats, cars and work

Technical Article

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 […]

You rated this post out of 5. Change rating

2007-06-06 (first published: )

662 reads

Technical Article

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)

You rated this post out of 5. Change rating

2007-01-30 (first published: )

6,875 reads

Technical Article

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 […]

You rated this post out of 5. Change rating

2005-07-04 (first published: )

218 reads

Blogs

ADF: Publish suddenly includes everything where it used to be incremental changes since the last publish

By

I recently encountered an interesting issue with ADF where the publish feature suddenly attempted...

Beginner’s Guide: Create a File Organizer CLI Tool in Rust

By

Image from Afdhaluddin on ShutterstockCLI which is generally referred to as Command Line Interface...

The Third Sabbatical

By

I can’t believe I’ve been at Redgate long enough to get a third sabbatical....

Read the latest Blogs

Forums

Azure Database Watcher Monitoring

By bokswager

Hi, I’ve provisioned an Azure Database Watcher to monitor our 4 Azure SQL Managed...

Can You Ask for a Raise?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Can You Ask for a...

Stored Procedure Generation Script

By Deepam Ghosh

Comments posted to this topic are about the item Stored Procedure Generation Script

Visit the forum

Question of the Day

Generating a Series I

What is returned by this code in SQL Server 2022?

SELECT value
FROM GENERATE_SERIES(4, 1);

See possible answers