In the event that you have to restore your database(s) from a backup, the instructions provided here provide guidance.
Caution: Use caution when restoring databases. Do not attempt to restore a database over an existing database unless you are sure you want to replace the data in the existing database with the data in the backup files you will restore from.
Two methods for restoring backups in MS SQL Server 2005 are described in this section. While the process for restoring from each type of backup are similar, there are some significant differences that need to be considered when you attempt to restore a database. Please review the following explanations before deciding on the appropriate database restoration procedure:
Restoring from scheduled maintenance plan backups - Databases that are backed up according to a recommended maintenance plan include daily full database backup files and incremental (transaction log) backup files created every two hours. Restoring from maintenance plan backups will give you the ability to include the transaction log files in your restoration.
Restoring from on-demand backups - On-demand backups are full database backups that you create during the course of upgrading the MetaCommunications Server, upgrading SQL Server 2000 to SQL Server 2005, or for any number of other reasons where it makes sense to create a full database backup instead of relying on the database backups created by your maintenance plan. One common situation where you would use this method is for restoring a database from a backup file recovered from tape or one that has been copied from another machine. The procedure for restoring from on-demand backups describes restoring from a full database backup without transaction logs.
Procedures
Restoring From Scheduled MS SQL Server 2005 Maintenance Plan Backups
Open Microsoft SQL Server 2005 Management Studio, log in, and navigateto the database you want to restore.
Select and right click the database you want to restore. A context menu will appear.
Note: If you want to restore your backup file(s) to a new database, right click any database in the list. You will have the opportunity to select an existing database or create a new database further on in the procedure.
Select Tasks, then Restore and Database... in the context menu (see above). The Restore Database window will open.
Check the name in the “To database” field. You can select an existing database to which you want to restore, or you can type the name of a new database in this field. Restoring to an existing database will replace any information in the current database with the information from the database backup files.
Select the “From database” radio button and select a database from thelist. All databases for which backup files are created by your database maintenance plan should be listed here. Once you have selected a database, existing full and incremental (transaction log) backup files for the selected database will appear in the list below.
Select the full and incremental database backups you want to restore from. Selecting all incremental backups will, by default, restore your database to the latest available point in time for which there is an incremental (transaction log) backup file. If, however, you want to restore to an earlier point in time, deselect the incremental (transaction log) backups that are more recent than the time from which you want to restore and proceed with the following steps.
If you are attempting to restore to an existing database: Select Options in the Page list on the left and enable the “Overwrite the existing database” checkbox.
If you are attempting to restore to an existing database: Select Options in the Page list on the left and browse to and choose the .mdf and .ldf files you want to overwrite with the restored database. By default, the path information will point to the original .mdf and .ldf files for which the backup was created and must be changed.
Click OK. A progress indicator will appear in the lower left hand corner of the Restore Database window.
When the database restoration is complete, the Complete window will appear.
Click OK in the Complete window. The window will close and return you to the MS SQL Server 2005 Management Studio.
If you have restored to an existing database, test the functionality of your Workgroups applications to ensure that everything is functioning as expected. If you have restored to a new database, you will need to create a database link in the Application Server and attach the database to any relevant MetaData Console snap-ins before you will be able to log in and test the database functionality with your Workgroups applications. See the Application Server User Guide and the MetaConsole Guide for more information.
Restoring From MS SQL Server 2005 Full On-Demand Backups
Open Microsoft SQL Server 2005 Management Studio, log in, and navigateto the database you want to restore.
Right click the database you want to restore. A context menu will appear.
Note: If you want to restore your backup file(s) to a new database, right click any database in the list. You will have the opportunity to select an existing database or create a new database further on in the procedure.
Select Tasks, then Restore and Database... in the context menu (see above). The Restore Database window will open.
Check the name in the “To database” field. You can select an existing database to which you want to restore, or you can type the name of a new database in this field. Restoring to an existing database will replace any information in the current database with the information from the database backup files.
Select the “From device” radio button then click Browse ( ). The Specify Backup window will open.
Click Add. The Locate Backup File window will open.
Browse to and select the backup file from which you will restore thedatabase. (See screen capture above).
Click OK. The Locate Backup File window will close, and the Specify Backup window will return, displaying the selected backup file in the list.
Click OK. The Specify Backup window will close, and the Restore Database window will return, displaying the specified backup file in the list.
Enable the Restore checkbox for the backup file selected in the previous step.
If you are attempting to restore to an existing database: Select Options in the Page list on the left and enable the “Overwrite the existing database” checkbox.
If you are attempting to restore to an existing database: Select Options in the Page list on the left and browse to and choose the .mdf and .ldf files you want to overwrite with the restored database. By default, the path information will point to the original .mdf and .ldf files for which the backup was created and must be changed.
Click OK. A progress indicator will appear in the lower left hand corner of the Restore Database window.
When the database restoration is complete, the Complete window will appear.
Click OK in the Complete window. The window will close and return you to the MS SQL Server 2005 Management Studio.
If you have restored to an existing database, test the functionality of your Workgroups application(s) to ensure that everything is functioning as expected. If you have restored to a new database, you will need to create a database link in the Application Server and attach the database to any relevant MetaData Console snap-ins before you will be able to log in and test the database functionality with your Workgroups applications. See the Application Server User Guide and the MetaConsole Guide for more information.
You might need to add your username to the Backup Operators group. It soudns li...
You might need to add your username to the Backup Operators group. It soudns like you are NOT a local administrator. You should log in to the computer as the Administrator and then follow these steps:To add a user to the Backup Operators groupOpen Computer Management. (right click on my computer and choose manage)In the console tree, click Groups.Where?Computer ManagementLocal Users and GroupsGroupsIn the details pane double-click Backup Operators.On the Backup Operators Properties dialog box, click Add.On the Select Users or Groups dialog box, next to Name, type the domain and user name of the person you want to make a backup operator. Type the domain name first, then a backslash, then the user name. For example, \LondonWilliam. (in this case this is your computer nameuser)Click Add, and then click OK. ImportantTo add a user to the Operators Group on a domain controller you must use Active Directory Users and Computers. For more information, click Related Topics. NotesYou must be a member of the Administrators group to designate users as Backup Operators.To open Computer Management, click Start, point to Settings, and then click Control Panel. Double-click Administrative Tools, and then double-click Computer Management.
, the devil is at the details And that could not be much more corcert in this a...
, the devil is at the details And that could not be much more corcert in this article. Having stated that, allow me reveal to you just just what did work. The writing could be rather powerful which is possibly the reason why I am taking hard work to opine. I usually do not really make it a normal habit of accomplishing that. Second, although I could see the leaps throughout logic you develop, I am not really certain of how we seem to be able to unite the important points which inturn make in conclusion. For the minute I shall yield for a position however hope soon you hook up your information better.
E-mail
Comments (51)
Nov 09, 2012
Anonymous says:
Hey, that's porwfuel. Thanks for the news.Hey, that's porwfuel. Thanks for the news.
Nov 17, 2012
Anonymous says:
You might need to add your username to the Backup Operators group. It soudns li...You might need to add your username to the Backup Operators group. It soudns like you are NOT a local administrator. You should log in to the computer as the Administrator and then follow these steps:To add a user to the Backup Operators groupOpen Computer Management. (right click on my computer and choose manage)In the console tree, click Groups.Where?Computer ManagementLocal Users and GroupsGroupsIn the details pane double-click Backup Operators.On the Backup Operators Properties dialog box, click Add.On the Select Users or Groups dialog box, next to Name, type the domain and user name of the person you want to make a backup operator. Type the domain name first, then a backslash, then the user name. For example, \LondonWilliam. (in this case this is your computer nameuser)Click Add, and then click OK. ImportantTo add a user to the Operators Group on a domain controller you must use Active Directory Users and Computers. For more information, click Related Topics. NotesYou must be a member of the Administrators group to designate users as Backup Operators.To open Computer Management, click Start, point to Settings, and then click Control Panel. Double-click Administrative Tools, and then double-click Computer Management.
Dec 06, 2012
Anonymous says:
http://www.mybestautoinsurer.com/ state auto insurance 1366 http://www.searchmed...http://www.mybestautoinsurer.com/ state auto insurance 1366 http://www.searchmedicalinfo.com/ prednisone pills 14209
Dec 07, 2012
Anonymous says:
http://www.edtabsprices.com/ where to buy viagra :-O http://www.cheapcarinsurrat...http://www.edtabsprices.com/ where to buy viagra :-O http://www.cheapcarinsurrates.net/ free car insurance quotes ngwzwj
Dec 07, 2012
Anonymous says:
http://www.myhealthline.co.uk/ chip health insurance 847773 http://www.compare-m...http://www.myhealthline.co.uk/ chip health insurance 847773 http://www.compare-meds.net/ cialis osp
Dec 07, 2012
Anonymous says:
http://www.edtabsprices.com/ viagra >:-O http://www.cheapcarinsurrates.net/ c...http://www.edtabsprices.com/ viagra >:-O http://www.cheapcarinsurrates.net/ car insurance rates =-OOO
Dec 08, 2012
Anonymous says:
http://www.getaccreditedonlinedegrees.net/ online colleges =]] http://www.treatp...http://www.getaccreditedonlinedegrees.net/ online colleges =]] http://www.treatpatternhairloss.com/ propecia generic prescription 712
Dec 08, 2012
Anonymous says:
http://www.getaccreditedonlinedegrees.net/ online colleges %]] http://www.pillsc...http://www.getaccreditedonlinedegrees.net/ online colleges %]] http://www.pillscompetitor.com/ cialis qrnvme
Dec 08, 2012
Anonymous says:
http://www.wisemotorist.co.uk/ car insurance =PP http://www.treatpatternhairloss...http://www.wisemotorist.co.uk/ car insurance =PP http://www.treatpatternhairloss.com/ order propecia online ing
Dec 08, 2012
Anonymous says:
http://www.getaccreditedonlinedegrees.net/ online colleges ychqrf http://www.tre...http://www.getaccreditedonlinedegrees.net/ online colleges ychqrf http://www.treatpatternhairloss.com/ propecia 6237
Dec 10, 2012
Anonymous says:
http://www.wisemotorist.co.uk/ cheap car insurance >:]] http://www.treatpatte...http://www.wisemotorist.co.uk/ cheap car insurance >:]] http://www.treatpatternhairloss.com/ propecia cyuz
Dec 10, 2012
Anonymous says:
http://www.wisemotorist.co.uk/ car insurance %( http://www.pillscompetitor.com/ ...http://www.wisemotorist.co.uk/ car insurance %
( http://www.pillscompetitor.com/ cialis =[[[Dec 10, 2012
Anonymous says:
http://www.wisemotorist.co.uk/ car insurance bvs http://www.getaccreditedonlined...http://www.wisemotorist.co.uk/ car insurance bvs http://www.getaccreditedonlinedegrees.net/ online colleges ejyom
Dec 12, 2012
Anonymous says:
http://www.pillscompetitor.com/ cialis 57887 http://www.treatpatternhairloss.com...http://www.pillscompetitor.com/ cialis 57887 http://www.treatpatternhairloss.com/ propecia >:-[[[
Dec 14, 2012
Anonymous says:
http://www.wisemotorist.co.uk/ car insurance xlmozn http://www.getaccreditedonli...http://www.wisemotorist.co.uk/ car insurance xlmozn http://www.getaccreditedonlinedegrees.net/ online colleges qfypz
Dec 18, 2012
Anonymous says:
, the devil is at the details And that could not be much more corcert in this a..., the devil is at the details And that could not be much more corcert in this article. Having stated that, allow me reveal to you just just what did work. The writing could be rather powerful which is possibly the reason why I am taking hard work to opine. I usually do not really make it a normal habit of accomplishing that. Second, although I could see the leaps throughout logic you develop, I am not really certain of how we seem to be able to unite the important points which inturn make in conclusion. For the minute I shall yield for a position however hope soon you hook up your information better.
Dec 18, 2012
Anonymous says:
http://www.quotesfromtopinsurers.com/ car insurance quotes jygcz http://www.best...http://www.quotesfromtopinsurers.com/ car insurance quotes jygcz http://www.bestautoinsurancepolicies.net/ car insurance qoutes =)
Dec 18, 2012
Anonymous says:
http://www.quotesfromtopinsurers.com/ car insurance quotes :-OO http://www.onlin...http://www.quotesfromtopinsurers.com/ car insurance quotes :-OO http://www.onlinecheapautoinsurance.net/ carinsurance uqgv
Jan 06, 2013
Anonymous says:
http://www.mynjquotes.com/ new york car insurance 8[ http://www.lifeinsurancesho...http://www.mynjquotes.com/ new york car insurance 8[ http://www.lifeinsuranceshopping.net/ term life insurance quotes npzb http://www.carinsuranceiseasy.com/ buy car insurance online 036328 http://www.insurancequotesfl.net/ florida auto insurance kblxar
Jan 06, 2013
Anonymous says:
http://www.mynjquotes.com/ auto insurance quotes nj rjy http://www.nycarinsurquo...http://www.mynjquotes.com/ auto insurance quotes nj rjy http://www.nycarinsurquotes.com/ free car insurance quotes oemxyb http://www.insurancequotesfl.net/ car insurance oyja http://www.treatpatternhairloss.com/ propecia pills fota
Jan 06, 2013
Anonymous says:
http://www.nycarinsurquotes.com/ auto insurance quotes ny geati http://www.onlin...http://www.nycarinsurquotes.com/ auto insurance quotes ny geati http://www.onlinecheapautoinsurance.net/ cheap auto insurance =-]]] http://www.quotesfromtopinsurers.com/ car insurance quotes 95437 http://www.carinsuranceli.com/ auto insurance quotes il ihale
Jan 07, 2013
Anonymous says:
http://www.txautoinsurquotes.com/ car insurance quotes tx :DDD http://www.online...http://www.txautoinsurquotes.com/ car insurance quotes tx :DDD http://www.onlinecheapautoinsurance.net/ cheap auto insurance eyrm http://www.cainsurancequotes.net/ cheapest car insurance 06229
Jan 07, 2013
Anonymous says:
http://www.onlinecheapautoinsurance.net/ cheap auto insurance =-] http://www.myl...http://www.onlinecheapautoinsurance.net/ cheap auto insurance =-] http://www.mylifeinsuranceguide.net/ insurance life 328 http://www.carinsuranceli.com/ cheap california auto insurance 8((( http://www.cainsurancequotes.net/ auto insurance quotes ca wopcwv
Jan 07, 2013
Anonymous says:
http://www.nycarinsurquotes.com/ car insurance quotes ny vwa http://www.mynjquot...http://www.nycarinsurquotes.com/ car insurance quotes ny vwa http://www.mynjquotes.com/ car insurance quotes nj jlzajr http://www.aboutcarinsurancerates.com/ auto insurance rates 96869 http://www.treatpatternhairloss.com/ propecia patent expiration generic :-DD
Jan 09, 2013
Anonymous says:
http://www.mynjquotes.com/ insurance auto refewb http://www.lifeinsuranceshoppin...http://www.mynjquotes.com/ insurance auto refewb http://www.lifeinsuranceshopping.net/ permanent life insurance kke http://www.aboutcarinsurancerates.com/ car insurance zkond
Jan 12, 2013
Anonymous says:
http://www.bestquotesga.com/ car insurance quotes ga =]] http://www.lifeinsuranc...http://www.bestquotesga.com/ car insurance quotes ga =]] http://www.lifeinsuranceshopping.net/ life insurance quotes mnhzq http://www.insurancequotesfl.net/ auto insurance quotes fl :
OO http://www.aboutcarinsurancerates.com/ low car insurance :[[[Jan 12, 2013
Anonymous says:
http://www.bestquotesga.com/ low car insurance 978 http://www.aboutcarinsurancer...http://www.bestquotesga.com/ low car insurance 978 http://www.aboutcarinsurancerates.com/ car insurance htv http://www.bestautoinsurancepolicies.net/ affordable car insurance 5660 http://www.treatpatternhairloss.com/ propecia >:[[[
Jan 17, 2013
Anonymous says:
http://cheapautoinsurer.net/ cheap auto insurance (( http://www.quotesfromtopins...http://cheapautoinsurer.net/ cheap auto insurance
(( http://www.quotesfromtopinsurers.com/ eastwood auto insurance nrthb http://www.lifeinsuranceshopping.net/ online life insurance 23000
Jan 17, 2013
Anonymous says:
http://www.autoinsurers4u.com/ auto insurance quotes sqvj http://www.mylifeinsur...http://www.autoinsurers4u.com/ auto insurance quotes sqvj http://www.mylifeinsuranceguide.net/ life insurance >:-PP http://www.carinsuranceiseasy.com/ insurance auto 885126
Jan 18, 2013
Anonymous says:
http://www.mylifeinsuranceguide.net/ low cost life insurance 85494 http://www.li...http://www.mylifeinsuranceguide.net/ low cost life insurance 85494 http://www.lifeinsuranceshopping.net/ whole life insurance 8-DDD http://www.aboutcarinsurancerates.com/ car insurance wwqx
Jan 21, 2013
Anonymous says:
http://www.carinsuranceiseasy.com/ cheap car insurance 8[ http://www.lifeinsuran...http://www.carinsuranceiseasy.com/ cheap car insurance 8[ http://www.lifeinsuranceshopping.net/ life insurance for seniors 8] http://edmedsinfo.com/ order viagra ohbyta http://www.treatpatternhairloss.com/ propecia 8]]]
Jan 21, 2013
Anonymous says:
http://www.autoinsurers4u.com/ cheap car insurance 8]]] http://www.quotesfromtop...http://www.autoinsurers4u.com/ cheap car insurance 8]]] http://www.quotesfromtopinsurers.com/ car insurance quotes jthr http://www.aboutcarinsurancerates.com/ car insurance >:-[[[ http://www.bestautoinsurancepolicies.net/ auto insurance %]
Jan 21, 2013
Anonymous says:
http://cheapautoinsurer.net/ cheap auto insurance 8-OOO http://www.quotesfromtop...http://cheapautoinsurer.net/ cheap auto insurance 8-OOO http://www.quotesfromtopinsurers.com/ auto insurance online kdduel http://www.mylifeinsuranceguide.net/ life insurance 754290 http://edmedsinfo.com/ viagra moqlq
Jan 21, 2013
Anonymous says:
http://www.quotesfromtopinsurers.com/ nj car insurance %) http://www.carinsuranc...http://www.quotesfromtopinsurers.com/ nj car insurance %) http://www.carinsuranceiseasy.com/ cheap car insurance xqfu http://www.aboutcarinsurancerates.com/ car insurance 851272
Jan 21, 2013
Anonymous says:
http://www.quotesfromtopinsurers.com/ car insurance quotes 1330 http://www.carin...http://www.quotesfromtopinsurers.com/ car insurance quotes 1330 http://www.carinsuranceiseasy.com/ cheap auto insurance yrrq http://www.mylifeinsuranceguide.net/ no exam life insurance uyxavw http://www.treatpatternhairloss.com/ propecia 814
Jan 21, 2013
Anonymous says:
http://www.onlinecheapautoinsurance.net/ cheap auto insurance > http://www.my...http://www.onlinecheapautoinsurance.net/ cheap auto insurance >
http://www.mylifeinsuranceguide.net/ life and health insurance aopqnn http://www.treatpatternhairloss.com/ propecia to buy 3848
Jan 22, 2013
Anonymous says:
http://www.carinsuranceiseasy.com/ cheap car insurance 75396 http://www.aboutcar...http://www.carinsuranceiseasy.com/ cheap car insurance 75396 http://www.aboutcarinsurancerates.com/ car insurance dxpxpw http://edmedsinfo.com/ viagra =[
Jan 22, 2013
Anonymous says:
http://www.carinsuranceiseasy.com/ cheap car insurance 627 http://www.aboutcarin...http://www.carinsuranceiseasy.com/ cheap car insurance 627 http://www.aboutcarinsurancerates.com/ low car insurance ponw http://www.bestautoinsurancepolicies.net/ auto insurance =-]]
Jan 22, 2013
Anonymous says:
http://www.onlinecheapautoinsurance.net/ auto insurance quotes ) http://www.cari...http://www.onlinecheapautoinsurance.net/ auto insurance quotes
) http://www.carinsuranceiseasy.com/ auto insurance online 773438 http://edmedsinfo.com/ viagra 8-P http://www.treatpatternhairloss.com/ propecia 8-DDD
Jan 23, 2013
Anonymous says:
http://www.lifeinsuranceshopping.net/ online life insurance ixfs http://www.abou...http://www.lifeinsuranceshopping.net/ online life insurance ixfs http://www.aboutcarinsurancerates.com/ cheap car insurance cjkaj http://www.bestautoinsurancepolicies.net/ insurance auto =-DD
Jan 23, 2013
Anonymous says:
http://cheapautoinsurer.net/ car insurance rates xet http://www.quotesfromtopins...http://cheapautoinsurer.net/ car insurance rates xet http://www.quotesfromtopinsurers.com/ auto insurance online lyc http://www.mylifeinsuranceguide.net/ life insurance 8]]] http://www.treatpatternhairloss.com/ propecia :-O
Jan 24, 2013
Anonymous says:
http://www.autoinsurers4u.com/ auto insurance quotes %-O http://www.carinsurance...http://www.autoinsurers4u.com/ auto insurance quotes %-O http://www.carinsuranceiseasy.com/ cheap car insurance jkhqer http://edmedsinfo.com/ viagra qxqn
Jan 24, 2013
Anonymous says:
http://www.carinsuranceiseasy.com/ online auto insurance quotes mbyo http://www....http://www.carinsuranceiseasy.com/ online auto insurance quotes mbyo http://www.lifeinsuranceshopping.net/ life insurance quotes 8-((( http://edmedsinfo.com/ viagra for woman 422885
Jan 24, 2013
Anonymous says:
http://cheapautoinsurer.net/ cheap auto insurance 8)) http://www.onlinecheapauto...http://cheapautoinsurer.net/ cheap auto insurance 8)) http://www.onlinecheapautoinsurance.net/ car insurance >:-[ http://www.carinsuranceiseasy.com/ cheap car insurance
http://edmedsinfo.com/ viagra :DD
Jan 24, 2013
Anonymous says:
http://cheapautoinsurer.net/ car insurance online rkufe http://www.carinsurancei...http://cheapautoinsurer.net/ car insurance online rkufe http://www.carinsuranceiseasy.com/ cheap car insurance 0475 http://www.bestautoinsurancepolicies.net/ eastwood auto insurance pied
Jan 24, 2013
Anonymous says:
http://www.quotesfromtopinsurers.com/ car insurance quotes iym http://www.mylife...http://www.quotesfromtopinsurers.com/ car insurance quotes iym http://www.mylifeinsuranceguide.net/ life insurance companies :
DD http://www.lifeinsuranceshopping.net/ life insurance quotes >:]]]Jan 24, 2013
Anonymous says:
http://www.quotesfromtopinsurers.com/ eastwood auto insurance 61432 http://www.c...http://www.quotesfromtopinsurers.com/ eastwood auto insurance 61432 http://www.carinsuranceiseasy.com/ insurance auto 501155 http://edmedsinfo.com/ viagra 2073 http://www.bestautoinsurancepolicies.net/ car insurance quotes %(
Jan 24, 2013
Anonymous says:
http://www.autoinsurers4u.com/ average car insurance rates rrjgs http://www.life...http://www.autoinsurers4u.com/ average car insurance rates rrjgs http://www.lifeinsuranceshopping.net/ life insurance quotes qguoh http://www.aboutcarinsurancerates.com/ low car insurance >
http://www.bestautoinsurancepolicies.net/ auto insurance 9275
Jan 27, 2013
Anonymous says:
http://www.autoinsurers4u.com/ car insurance quote %-( http://www.onlinecheapaut...http://www.autoinsurers4u.com/ car insurance quote %-( http://www.onlinecheapautoinsurance.net/ auto insurance quotes swstlu http://www.bestautoinsurancepolicies.net/ insurance auto 2461
Jan 27, 2013
Anonymous says:
http://www.onlinecheapautoinsurance.net/ cheap car insurance 687 http://www.abou...http://www.onlinecheapautoinsurance.net/ cheap car insurance 687 http://www.aboutcarinsurancerates.com/ car insurance %-]] http://www.treatpatternhairloss.com/ to buy propecia 70687
Jan 28, 2013
Anonymous says:
http://cheapautoinsurer.net/ cheap auto insurance eecsgm http://www.onlinecheapa...http://cheapautoinsurer.net/ cheap auto insurance eecsgm http://www.onlinecheapautoinsurance.net/ cheap auto insurance >:
DDD http://www.lifeinsuranceshopping.net/ life insurance policy 8)) http://www.aboutcarinsurancerates.com/ car insurance 130291