I have a SQL Server database that's 145GB, about 80% of that space is occupied by "files". Staff have the ability to upload files from the web front end application into the database, this is used ...

These backup files have names ending with the ".bak" file extension, and you use them to restore database backups through Microsoft SQL Server. by navigating to the backup utility and loading the ...

If you have accidently deleted data from database tables in MS SQL Server, you can restore the deleted data (tables) using Log Sequence Number (LSN). But for this, you need the transaction backup file ...

FileTables, a new feature introduced in SQL Server 2012, is a unique table that reflects metadata of files in a specified folder.

We have an ancient AS/400 730 system that still houses some old budget/financial data. We'd like to decommission this box, and migrate the data to a SQL server. The data won't be modified or ...

The valuable data can be easily restored with the help of a powerful recovery tool — DataNumen SQL Recovery. This program uses DataNumen proprietary technology to scan the corrupt file byte by ...

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database.

Mounting SQL Server data files over the internet seems an odd thing to do, considering the latency and possible unreliability of such a connection, but this feature is mainly designed for SQL ...