Lennart Gerdvall

  • Interests: Boats, cars and work

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

649 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,855 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: )

209 reads

Blogs

SQL Server on Kubernetes Book Published!

By

I’m super proud to announce that Ben E. Weissman and I have published SQL...

Gathering More Digital Data with Tile Slim

By

After my wallet misadventures, I ordered a Tile Slim to track my wallet. It...

Accessibility is not just about slides

By

Although I don’t write about it much on this website, I am on the...

Read the latest Blogs

Forums

subreport blank lines

By ibax

blank line in subreport

Enabling indexes

By SQLHeap

If I disable an index for a large insert/update/delete, what happens when it's enabled...

Database Triggers

By mballentine

Hi, I need to send out an email every time an alarm level is...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers