August 3, 2005 at 12:25 pm
Is there a way using EM to set an SQL Backup to a domain that the SQL admin account is not a member of? Entering a fully qualified pathname for the backup location (i.e \\servername.domain\share\path) returns the message 'Unable to verify the existence of the backup file location. Do you want to use the backup file location anyway'. There doesn't seem to be any place/chance to enter the authentication credentials for the other domain.
Thanks
Tim
August 4, 2005 at 4:27 am
You need to ensure that the correct trust relationship is set up between the two domains. After that, grant the account that starts SQL Server the necessary permissions on the share that you wish to use for your backups. That way, you will be using the authentication credentials of the service account, so there is no need to enter any details when you enter the path.
August 4, 2005 at 11:13 am
You don't want to do this. The backup process is extremely intolerant of network delays and you'll find it failing for no apparent reason. You'd be better off backing up locally and then copying and deleting your local copy.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
August 5, 2005 at 11:48 am
Also, network backups are very slow and tend to saturate even the largest networks. Best practices recommend that you backup up your databases locally and then copy them to your network drive. If you do not have the disk space to backup locally, try looking at a compression utility such as LiteSpeed (www.imceda.com).
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply