SQL Server with Mr. Denny:

Restore Database

1

June 25, 2012  2:00 PM

Moving huge amounts of data between data centers



Posted by: Denny Cherry
Data Center Build, Migration, Restore Database, SQL Server

Every once and a while I get the fun project of moving a data center from one location to another, often from a Managed Service Provider to either a CoLo facility or to another Managed Service Provider.  When I'm doing this the data sizes typically aren't small.  In the case of my current project...

May 28, 2012  2:00 PM

Figuring out how log shipping is doing



Posted by: Denny Cherry
Backup & recovery, Log Shipping, Migration, Restore Database, SQL Server

A lot of the time when doing data center migrations or system migrations I end up using Transaction Log Shipping to get the data from one SQL Server to another.  I do this for a few reasons.

  1. It's reliable.
  2. It's easy to do (I've got plenty of scripts sitting around to...


August 22, 2011  2:00 PM

There’s a little something to keep in mind when restoring a SQL replication publisher



Posted by: Denny Cherry
Backup & recovery, Replication, Restore Database

So the other day I had to restore the SQL Server replication publisher.  When I restored it I made sure to use the KEEP_REPLICATION option on the restore (also available in the SSMS UI) so replication should come back online.  However when I restarted the log reader I the following error...


May 30, 2011  2:00 PM

How to use the WITH MOVE when you don’t know the logical database file names.



Posted by: Denny Cherry
Restore Database, SQL Server

When doing a database restore and you want to move the physical database files from one disk to another, or from one folder to another you need to know the logical file names.  But if you can’t restore the database how do you get these logical file names?  By using the RESTORE FILELISTONLY...


February 2, 2010  11:00 AM

Taking backups is good, but testing them is better.



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, Restore Database, Testing

I bet that if asked when the last time the database backup was taken and if it succeeded you would know off of the top of your head when that was.  But if I asked you when the last time your database was restored successfully would you know?


December 29, 2008  11:00 AM

Order To Restore Database Backups In



Posted by: Denny Cherry
Backup & recovery, Restore Database, RESTORE LOG

I'm often asked (both online and offline) once you have all your database backups, in what order to they need to be restored in? I've actually asked this very question to senior level DBAs as an interview question before, and gotten some very interesting answers. When restoring your database...


August 11, 2008  11:00 AM

Back To Basics: The RESTORE DATABASE Command



Posted by: Denny Cherry
Back To Basics, Restore Database, SQL

The restore database command is what is used to recover a database which has been backed up using the BACKUP DATABASE command.  The syntax of the RESTORE DATABASE...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: