SQL Database Restore to "Master?"

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Kim@shore Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: March/31/05 Location: United States Status: Offline Points: 5	Post Options Post Reply Quote Kim@shore Report Post Thanks(0) Quote Reply Topic: SQL Database Restore to "Master?" 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

Techno Geek Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Evil monkey living in my closet! Joined: March/11/04 Location: United States Status: Offline Points: 1206	Post Options Post Reply Quote Techno Geek Report Post Thanks(0) Quote Reply 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
	Techno Geek Customer Support Engineer ComCity and SalesCart Technical Support

Kim@shore Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: March/31/05 Location: United States Status: Offline Points: 5	Post Options Post Reply Quote Kim@shore Report Post Thanks(0) Quote Reply 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