[ANSWERED] How Do I Backup MS SQL to a UNC path?
Got a question here on MS SQL. I have 2 MS SQL servers, both the 2005 edition and running the SQL Server Management Studio. One of the servers is the full software suite, the other is the express suite due to not having a second license. Both work great. So here's the issue, I've been programming proper backup schedules over the summer. Everything runs at it's specified time, all files etc. and important items on the network are now backed up automagically, and the only part I'm wondering about now is these two SQL servers and how to back them up.
I started with a Maintenance plan in SQL Server 2005 [Full] and thought I could program a backup there, but it didn't like that. I'm trying to backup to a UNC path. However, when I enter in a UNC path the backup errors out and doesn't like it. When I was originally configuring the backup, it took me about 12 clicks of the OK button at the bottom before it finally accepted the UNC path, it kept saying it couldn't resolve the path I had placed in there for where the backup was to be sent. Somehow I had the great idea of continuously clicking ok, and it accepted and allowed it. Now if I go in and edit it, place in the same UNC path, it accepts it [weird]. So anyway, I tried to run the backup and again I get an error. I checked the logs and it said access is denied when trying to create the backup at that location. I've been backing up with an account for backups only, and my domain administrator account, those are the only 2 users who have access to the backups, no other users can read them or write to those shares. So I thought ok, MAYBE it's because I'm using the SA account as SQL authentication and not my integrated Windows login. So I tried logging in as integrated while logged into my domain administrator account and to verify I had access, I entered in the UNC path into the run command in windows and made a new folder in the share when it came up. So far so good, nothing wrong with the share.
So the only issue now is getting MS SQL to actually write to the share. Am I doing anything wrong that you can see?
As an alternative, I know SQL Express isn't going to allow me to do that since there's no automated backups. Is it possible for these two database servers, to just backup the database folder in program files that holds the actual databases using NTBackup? Or is that a bad idea?
Edit: Just changed the backup location to my desktop in a new folder and it works perfectly there.