Category: sql-server

Creating SQL Server backup file (.bak) with c# to any location

Post author By user user
Post date February 19, 2022
Categories In backup, c++, permissions, sql-server
5 Comments on Creating SQL Server backup file (.bak) with c# to any location

I’m trying to write simple application in C# which will allow me to backup, zip and send over ftp my SQL Server database. One problem I have encountered is that I’m not able to create the backup file (.bak) if I try to do it in different location than “C:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\Backup” or “C:\Program […]

Combining SQL results using LINQ

Post author By user user
Post date February 19, 2022
Categories In sql-server
2 Comments on Combining SQL results using LINQ

I have a database of company registrants (for a search/directory functionality). We’ve added a new table to hold “enhanced” information for registrants that pay for this feature (such as advertisements/additional images/logos etc). Right now the new table just holds the registrants unique identifier, and a few additional fields (paths to images etc). A user can […]