SQL Database Restore to "Master?"

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

   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

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 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

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 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