Does anyone know how to run a copy of the same DB on the same server
with a different name.
Please hellp since we want to test some outputs and customisations with our
current data from our live DB.
Thanks.
Nigbev.
Run the following script.
USE
SIVDevSystem -- The new restored database.
UPDATE
Company
SET
DatabaseName = 'SIVDevApp', -- Point to restored application database name.
CpnyName = 'Test Company' -- Company name - displays in file menu and on
reports.
WHERE
CpnyID = '0100'
SELECT -- Check update.
CpnyID,
DataBaseName,
CpnyName
FROM
Company
UPDATE
Domain
SET
-- ServerName = ServerName, -- Only if restored to different sever.
DatabaseName = 'SIVDevApp' -- Point to restored application database name.
WHERE
DatabaseName = 'SIVHTGApp'
SELECT -- Check update.
DatabaseName,
ServerName
FROM
Domain
WHERE
DatabaseName = 'SIVDevApp'
Once that's done you log into Solomon using the test database and do your
necessary tests without fearing corrupting live data.
Cheers,
Sos
---
Rohtash Kapoor
http://www.microsoftdynamicsforums.com
"Sos" <S...@discussions.microsoft.com> wrote in message
news:386D4E23-2E46-4946...@microsoft.com...
"Rohtash Kapoor" <rohtash...@microsoftdynamicsforums.com> wrote in
message news:%23%23kdne6$FHA...@tk2msftngp13.phx.gbl...
847681- Restore Solomon databases for testing or archive purposes
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;847681
Kind Regards,
Amy Junkins
Microsoft Online Support
Certified Master – Solomon Applications
Certified Professional – Solomon Installation and Configuration
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.