|
Great Plains Support: How to recover Suspicious company Database Alba Spectrum
Microsoft Great Plains from time to time falls to the situation, when the problem really sits at the MS SQL Server level and you need to do SQL scripting in SQL Query Analyzer. Very good example of this is when you were recovering company DB from backup and for some reason restoration process failed and company is in permanent restoring limbo or marked as Suspicious in SQL Enterprise Manager. If you are trying to login GP gives you error messages, starting with the one about the error in Pallet Master table. Follow these guidelines:
1. Make backup of Master database in SQL. This is needed to roll back if our recommendation doesnt work in your environment. How to restore master database you should read SQL Server Books on line
2. Use sp_detach_db procedure to detach Suspicious database. Unfortunately you can not do it in SQL Server Enterprise Manager. This is why you do it in Query Analyzer. If you are not familiar, please read SQL Books on line for the syntax of the command.
3. To reattach database use sp_attach_single_file_db, which allows you do not deal with potentially corrupted log file. This command allows you to restore database to production state in SQL from DB MDB file. Normally you can reattach the same DB file which was marked as Suspicious, as the file is probably a good one and restoration failed somewhere on auxiliary steps. If you can not reattach, then simply try to restore from backup now you can do it as DB doesnt exist
4. MS SQL Server version. This problem was common for SQL 2000. If you are on SQL 2005, you can try our recommendations, however we never heard so far this problem on 2005
5. Additional recommendations. The ownership of the DYNAMICS and company database should belong to the role DYNSA. If you restore from backup you reset ownership to sa or domain administrator in most of the cases. We recommend you to change ownership back to DYNSA sometimes we see problem in GP version upgrades, when ownership belongs to different account
Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com , please call us: 1-630-854-0597, 1-866-528-0577, help@albaspectrum.com . We also recommend you to visit our information portal Pegas Planet: http://www.pegasplanet.com . Taisia Karaseva is Pegas Planet editor and concept author
Company: Alba Spectrum Group
|
| Related press releases |
Great Plains Support: How to recover Suspicious company Database Alba Spectr... [2008-02-13 05:56:18]
Microsoft Great Plains from time to time falls to the situation, when the problem really sits at the MS SQL Server level and you need to do SQL scripting in SQL Query Analyzer. Very good example of t...
|
|
Microsoft Great Plains Boca Raton, FL Alba Spectrum Group [2007-12-23 04:52:45]
Microsoft Business Solutions Great Plains is gaining market share as we write these lines. Alba Spectrum Group is announcing its Florida GP consultants headcount increase. If you have concerns about...
|
|
Ecommerce design for Microsoft Dynamics GP Great Plains Alba Spectrum [2007-08-18 03:29:33]
Alba Spectrum Group http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Great Plains backed ecommerce websites are very popular and considering Alba Spectrum ...
|
|
eConnect Posting Extension: Alba Spectrum Autoposting Server [2008-05-21 22:54:55]
If you are ecommerce developer, who are programming in C# or VB.Net with some SQL stored procedures, then more likely you are deploying Microsoft Dynamics GP eConnect SDK to integrate eCommerce websit...
|
|
Microsoft Dynamics GP 10.0 Visual Studio Development notes Alba Spectrum [2007-08-26 04:23:08]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
If you are eCommerce programmer and plan to dive into Microsoft Great Plains e-commerce web des...
|
|
Microsoft Dynamics GP Great Plains Integration and Upgrade Service in Chicago ... [2007-11-02 07:45:12]
Former Great Plains Software, later on Microsoft Business Solutions Great Plains and currently finally Microsoft Dynamics GP ERP application serves to midsize and large US businesses, also it has Cana...
|
|
Planning upgrade for Microsoft Dynamics GP Great Plains Alba Spectrum [2007-08-08 04:56:42]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
If you are on the way to upgrade GP versions 7.5, 8.0, 9.0 to GP 10.0, then you should read thi...
|
|
Great Plains Version Upgrade Microsoft Dynamics GP installation notes Alba Spe... [2007-10-07 03:20:00]
Alba Spectrum Group: http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Business Solutions Great Plains Dynamics GP version update technology seems to be str...
|
|
Microsoft Dynamics GP Great Plains and MS CRM tandem as corporate ERP Alba Spe... [2007-09-08 06:16:58]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Dynamics ERP products family includes both Great Plains and Microsoft CRM, so it is i...
|
|
Microsoft Dynamics GP 10.0 Project Green Advances or future ERP trends Alba Sp... [2007-08-23 04:21:37]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
In around 2003 Microsoft stated about Project Green that it will be merging several Microsoft j...
|
|
|
|
| Smoke Free Subliminal Health Program |
 Get quit smoking support through mental self help with this brain wave stimulating visual subliminal message stop smoking program. DEMO WIN/MAC |
|
| Melomania |
 Melomania is a handy music collection software for Windows, which allows you to catalog music collection of any kind, from vinyls to MP3s, and provides you with a quantity of facilities to manage music database. |
|
| 2P Barcode Creator |
 Powerful yet easy-to-use barcode generation program which you can trust to meet your barcode everyday needs anywhere your business leads to.Supports most barcodes.Many field types:Oval,RoundRect,Border styles,Pictures,Shapes.Support incremental data. |
|
| PSPad editor |
 PSPad editor is a programmers editor with support for multiple syntax highlighting profiles. It comes with a hex editor, CP conversion, text differences, templates, macros, spellcheck option, auto-completion, Code Explorer and much more. |
|
| VideoDesktop Dream Scape |
 Dream Scape Video Desktop uses very few of the computers resources. Hotkey support and snap shot tool with zoom preview. Get a fun, amazing and different desktop manager today and place your favorite video clips on your desktop! |
|
| Screen Paver |
 Screen Paver is an easy to use make-your-own slide show screen saver. The program will display an unlimited number of your own jpeg, png, or bitmap images from local and/or network directories. Plays music too. Great for digital camera users. |
|
| egrID3 COM Add-In for Microsoft Excel |
 egrID3 COM Add-In for Microsoft Excel adds functionality to fast mp3 ID3 v1.x, v2.3, v2.4 tag reading and altering, playlists generation, FreeDB querying, file names handling and full Unicode support on all operations. Handle compressed v2.x frames. |
|
|
Latest press releases
