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: )

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

(10)

You rated this post out of 5. Change rating

2007-01-30 (first published: )

6,882 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: )

223 reads

Blogs

T-SQL Tuesday #192: SQL Server 2025 Backup Changes

By

I hosted this month, but I decided to put my own entry in as...

Why Databases Still Fascinate Me

By

I get asked a lot about why or how I began working with databases...

Monday Monitor Tips: ServiceNow Integration

By

Earlier this year I visited a customer that was using the Redgate Monitor webhook...

Read the latest Blogs

Forums

Member was not found in the cube when the string

By giles.clapham

Hey, I've not done a cube for many years but I find myself supporting...

Implementing PostgreSQL with Python for Real-Time Logging and Monitoring

By sabyda

Comments posted to this topic are about the item Implementing PostgreSQL with Python for...

Identify a Slipstream Installation

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Identify a Slipstream Installation

Visit the forum

Question of the Day

Identify a Slipstream Installation

I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?

See possible answers