Restore .trn
in [Server Configuration]
|
From: Chris on 30 Jun 2008 12:24 Hi all, I would like to test that restorations are working from the .bak that is created each night and .trn files that are created every 6 hours. How do we go about it? I hear we may have to use a 3rd party application, but I'm open to suggestions. Thanks Chris
From: Andrew J. Kelly on 30 Jun 2008 13:17 Why would you have to use a 3rd party app? Just restore the backups to another instance of sql server or to the same instance with a different name and file locations. You can do this from the command line or from SSMS. Be careful of restoring to the same instance if you have never done that before so you don't hose your original db. By the way you should reconsider why you are only doing log backups every 6 hours. You risk up to 6 hours worth of data loss that way. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Chris" <Chris(a)discussions.microsoft.com> wrote in message news:46729206-561D-4357-8DB7-9E5303544273(a)microsoft.com... > Hi all, > > I would like to test that restorations are working from the .bak that is > created each night and .trn files that are created every 6 hours. How do > we > go about it? > > I hear we may have to use a 3rd party application, but I'm open to > suggestions. Thanks > > Chris
From: Chris on 1 Jul 2008 10:54 Andrew, Thanks for the info...the reason I ask is I've only done it with .baks before...but never .bak and .trn. If you could give me a quick step by step that would be great please. Thanks! Chris "Andrew J. Kelly" wrote: > Why would you have to use a 3rd party app? Just restore the backups to > another instance of sql server or to the same instance with a different name > and file locations. You can do this from the command line or from SSMS. Be > careful of restoring to the same instance if you have never done that before > so you don't hose your original db. By the way you should reconsider why you > are only doing log backups every 6 hours. You risk up to 6 hours worth of > data loss that way. > > -- > Andrew J. Kelly SQL MVP > Solid Quality Mentors > > > "Chris" <Chris(a)discussions.microsoft.com> wrote in message > news:46729206-561D-4357-8DB7-9E5303544273(a)microsoft.com... > > Hi all, > > > > I would like to test that restorations are working from the .bak that is > > created each night and .trn files that are created every 6 hours. How do > > we > > go about it? > > > > I hear we may have to use a 3rd party application, but I'm open to > > suggestions. Thanks > > > > Chris > >
From: Tibor Karaszi on 1 Jul 2008 11:06 Since you are testing restore, I assume that you have some degree of responsibility for restore. I'm saying this just se we agree on the bar here: You are familiar with both database as well as log restore. If that isn't the case, I suggest you talk to your employer to shell out for some education/study time. This I say for the benefit for both you as well as your employer. Having said above, and assuming you are familiar with log restore in general: You said you've done this (test restore on other machine) for db backup but not log backups. No problem. The restore process for log backups is the same when done to some other machine as when "local". Specify NORECOVERY for all but the last restore command. And you only need to specify MOVE options for the first (DB) restore. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Chris" <Chris(a)discussions.microsoft.com> wrote in message news:2007CCE1-0AD4-4F68-99A7-D5A7A3EC850A(a)microsoft.com... > Andrew, > > Thanks for the info...the reason I ask is I've only done it with .baks > before...but never .bak and .trn. If you could give me a quick step by step > that would be great please. Thanks! > > Chris > > "Andrew J. Kelly" wrote: > >> Why would you have to use a 3rd party app? Just restore the backups to >> another instance of sql server or to the same instance with a different name >> and file locations. You can do this from the command line or from SSMS. Be >> careful of restoring to the same instance if you have never done that before >> so you don't hose your original db. By the way you should reconsider why you >> are only doing log backups every 6 hours. You risk up to 6 hours worth of >> data loss that way. >> >> -- >> Andrew J. Kelly SQL MVP >> Solid Quality Mentors >> >> >> "Chris" <Chris(a)discussions.microsoft.com> wrote in message >> news:46729206-561D-4357-8DB7-9E5303544273(a)microsoft.com... >> > Hi all, >> > >> > I would like to test that restorations are working from the .bak that is >> > created each night and .trn files that are created every 6 hours. How do >> > we >> > go about it? >> > >> > I hear we may have to use a 3rd party application, but I'm open to >> > suggestions. Thanks >> > >> > Chris >> >>
From: Chris on 1 Jul 2008 11:14
Hi all, If anyone can elaborate / give an actual step by step guide I'd greatly appreciate it. Can .trn restores be done through both the management console and also using scripts? Thanks Chris "Tibor Karaszi" wrote: > Since you are testing restore, I assume that you have some degree of responsibility for restore. I'm > saying this just se we agree on the bar here: You are familiar with both database as well as log > restore. If that isn't the case, I suggest you talk to your employer to shell out for some > education/study time. This I say for the benefit for both you as well as your employer. > > Having said above, and assuming you are familiar with log restore in general: > You said you've done this (test restore on other machine) for db backup but not log backups. No > problem. The restore process for log backups is the same when done to some other machine as when > "local". Specify NORECOVERY for all but the last restore command. And you only need to specify MOVE > options for the first (DB) restore. > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://sqlblog.com/blogs/tibor_karaszi > > > "Chris" <Chris(a)discussions.microsoft.com> wrote in message > news:2007CCE1-0AD4-4F68-99A7-D5A7A3EC850A(a)microsoft.com... > > Andrew, > > > > Thanks for the info...the reason I ask is I've only done it with .baks > > before...but never .bak and .trn. If you could give me a quick step by step > > that would be great please. Thanks! > > > > Chris > > > > "Andrew J. Kelly" wrote: > > > >> Why would you have to use a 3rd party app? Just restore the backups to > >> another instance of sql server or to the same instance with a different name > >> and file locations. You can do this from the command line or from SSMS. Be > >> careful of restoring to the same instance if you have never done that before > >> so you don't hose your original db. By the way you should reconsider why you > >> are only doing log backups every 6 hours. You risk up to 6 hours worth of > >> data loss that way. > >> > >> -- > >> Andrew J. Kelly SQL MVP > >> Solid Quality Mentors > >> > >> > >> "Chris" <Chris(a)discussions.microsoft.com> wrote in message > >> news:46729206-561D-4357-8DB7-9E5303544273(a)microsoft.com... > >> > Hi all, > >> > > >> > I would like to test that restorations are working from the .bak that is > >> > created each night and .trn files that are created every 6 hours. How do > >> > we > >> > go about it? > >> > > >> > I hear we may have to use a 3rd party application, but I'm open to > >> > suggestions. Thanks > >> > > >> > Chris > >> > >> > > |