December 17, 2008 at 1:12 pm
We just moved over to Sql 2005. When we create backup plans the only drive we see when clicking the button is the drive that Sql is installed on. Now we can put in different location on bottom line but is there a way to add those drive locations so that we can click on those locations through the studio management and not have to type them in.
December 17, 2008 at 1:51 pm
Sounds to me like this instance of SQL Server is in a cluster. If so, you need to add the other drives as dependencies for SQL Server in Cluster Administrator. This will require that you take SQL Server offline, add the dependencies and then bring it back online.
Once completed - you should see the additional drives available.
Now, if these additional drives are mapped drives - then SQL Server will not see them and you will have to use UNC to access them.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 17, 2008 at 2:57 pm
The location window will NOT show Mapped drives as above post said
You have to either
1. use T-SQL to backup to UNC path
BACKUP DATABASE [db] TO DISK = '\\Server\Share\db.bak'
2. Add the UNC path as Backup Device
then you can select either Disk or Device for the backup location
EXEC master.dbo.sp_addumpdevice @devtype = N'disk', @logicalname = N'\\Server\E$', @physicalname = N'C:\Backup\\\Server\E$.bak'
December 18, 2008 at 6:46 am
Thanks for all the info, I went in and added a backup device with the UNC and it worked. We can see the named paths to backup too instead of typing in every time. Thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply