Sometimes, as when testing a table in a Microsoft SQL Server database, you need to reset an identity column to its initial seed value, typically one. During testing, you populate the table with data, ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

So I've had a case open with Microsoft since October concerning SQL databases that I cannot restore from DPM unless I run a consistency check on them first. Today, it seems they assigned to me yet ...