SQL Database Restore to "Master?"
Printed From: SalesCart
Category: Legacy Products
Forum Name: SalesCart Standard / PRO / SQL
Forum Description: All questions pertaining to SalesCart Standard, PRO and SQL should be posted here.
URL: http://forum.salescart.com/forum/forum_posts.asp?TID=380
Printed Date: November/23/24 at 5:48pm
Software Version: Web Wiz Forums 11.04 - http://www.webwizforums.com
Topic: SQL Database Restore to "Master?"
Posted By: Kim@shore
Subject: SQL Database Restore to "Master?"
Date Posted: July/21/05 at 8:15am
I am in the process of restoring the SalesCart SQL database to "Master" for SalesCartSQL.
The SalesCart manual states that I should restore the database using the Enterprise Manager in SQL by:
" Navigating to SQL Server Database > Database > Master > "
However, with a shared hosting platform, the "Master" database is a default SQL installed database with no permissions. Instead there is the "<LoginName>" database that I am given full permissions to.
I am concerned about the possiblility of modifications I may have to make to SalesCart to have it functioning properly. In your experience, are there any changes I need to make to the DSN or the Client Network Utility (outside of the norm) to make sure that I do not experience any problems in the SalesCart Integration?
Your help is genuinely appreciated.
Thanks,
Kim
|
Replies:
Posted By: Techno Geek
Date Posted: July/21/05 at 4:53pm
You're not restoring it on the MASTER. You create a new database, then either restore the backup file or run the .SQL script via the Enterprise Manager query analyzer. The instructions for both methods are stored in the /SQL-Admin directory.
Needless to say, you have to have your host restore the database since you are on a shared server and they only have the proper permissions to do this.
-------------
Techno Geek
Customer Support Engineer
ComCity and SalesCart Technical Support
|
Posted By: Kim@shore
Date Posted: July/21/05 at 7:33pm
Thank you for your quick reply. I was a little lost as to whether you literally meant the "MASTER."
Onward and upward!
Best regards,
Kim
|
|