How to backup a SQL Server database to a network drive
At least in SQL Server 2005 and 2008 – mind you, you should be using a newer version than those mentioned – backing up a database to a network drive is not immediately possible. I am not sure if it is just a security reason, but in the end it does not matter if you really have no other option like it happened to me. A legacy product is still using an older version of SQL Server and I needed a copy of a database, but did not have enough space on the SQL server itself to do so. The only option available was to use a mapped drive. However, SQL Server is tricky and does not accept a mapped drive that was only mapped on the OS level; SQL Server wants its own drive mapping. [Read more…] about How to backup a SQL Server database to a network drive