SQL Server Backup Failed. Cannot Open Backup Device – Network Drive / UNC

When trying to backup a SQL Server database to a network drive or UNC path, you get the following error: Microsoft SQL Server Management Studio Backup failed for Server <<SQL Server>>. (Microsoft.SqlServer.SmoExtended) Additional information: System.Data.SqlClient.SqlError: Cannot open backup device “<<UNC path / Network drive>>’. Operating system error 32 (The process cannot access the file because […]
Continue reading…

 

Invalid Prefix Or Suffix Characters. (MS Visual Database Tools) – SQL Server Management Studio

When trying to edit the top 200 rows of a database through the GUI (Right clicking on a database in SQL Server Management Studio and clicking Edit Top 200 Rows), you can get the following error message: Microsoft SQL Server Management Studio Invalid prefix or suffix characters. (MS Visual Database Tools) This occurs when you […]
Continue reading…