http://forum.salescart.com/forum/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 11 Mar 2026 08:13:59 +0000 Thu, 21 Jul 2005 19:33:17 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.04 360 forum.salescart.com/forum/RSS_post_feed.asp?TID=380 http://forum.salescart.com/forum/forum_images/web_wiz_forums.png http://forum.salescart.com/forum/ http://forum.salescart.com/forum/forum_posts.asp?TID=380&PID=1381&title=sql-database-restore-to-master#1381 Author: Kim@shore
Subject: 380
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

Edited by Kim@shore]]> Thu, 21 Jul 2005 19:33:17 +0000 http://forum.salescart.com/forum/forum_posts.asp?TID=380&PID=1381&title=sql-database-restore-to-master#1381 http://forum.salescart.com/forum/forum_posts.asp?TID=380&PID=1380&title=sql-database-restore-to-master#1380 Author: Techno Geek
Subject: 380
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.

Edited by Techno Geek]]> Thu, 21 Jul 2005 16:53:41 +0000 http://forum.salescart.com/forum/forum_posts.asp?TID=380&PID=1380&title=sql-database-restore-to-master#1380 http://forum.salescart.com/forum/forum_posts.asp?TID=380&PID=1371&title=sql-database-restore-to-master#1371 Author: Kim@shore
Subject: 380
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




]]> Thu, 21 Jul 2005 08:15:42 +0000 http://forum.salescart.com/forum/forum_posts.asp?TID=380&PID=1371&title=sql-database-restore-to-master#1371