Advertisement

08.21.2008 at 06:52AM PDT, ID: 23666694 | Points: 500
[x]
Attachment Details

Restoring a Great Plains database with SQL 2000

Asked by TacomaVA in Microsoft Dynamics, MS SQL Server

Tags: , , ,

I have a Microsoft SQL 2000 server that hosts the GreatPlains 9.0 database and software.  A user deleted some important information this morning and I need to restore the GP database to yesterdays.  I have a copy of the database as of yesterday.  Do I simply need to launch MS SQL 2000 and then right click my GP database and click 'Restore Database'?  Is it that simple or is there more to it?  Also I have a database listed as DYNAMICS in addition to my main GP database, will I need to restore the DYNAMICS database as well?

ThanksStart Free Trial
[+][-]08.21.2008 at 08:32AM PDT, ID: 22280635

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20081112-EE-VQP-42 / EE_QW_2_20070628