Re: ISV Using SQL Authentication - a login concern

From: dev (anonymous_at_discussions.microsoft.com)
Date: 05/26/04 

Date: Wed, 26 May 2004 14:01:05 -0700

Thanks Geoff, some more question (sorry about so many qs):
-do I need to start the SQLServer service before backing up or restoring from my app. (generally for simple db work there is no need to start the service)
-Is it best to store the backup and restore T-SQL command in stored procedures. If yes then I will keep them in my app's database. But if I want to backup Master db too then is it ok to say "Use Master" in stored procedure which is residing in my app's db.

I am sorry if these questions have too simple reply. I am learning (fast)

Thanks