Hello,I have a few databases on a MSSQL 2005 server that where reloaded from backups from a SQL 2000 server a few month ago.Today, I noticed that these databases had a strange "status": "Shutdown ...

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 ...

Do you need to find out where the location of your SQL Server's database is? Here's a quick tip. Written by Arthur Fuller, Contributor. Contributor. March 4, 2004 at 12:45 a.m. PT.

Name Owner Status RecoveryModel---- ----- ----- ----- ... We will now use a similar technique that I covered when I created the SQL server login to create the database user account on the ...

Most Common Wait Types in SQL Server and What They Mean. ASYNC_NETWORK_IO—The async_network_io wait types point to network-related issues. They are most-often caused by a client application not ...

In Azure SQL Database you can also set a HISTORY_RETENTION_PERIOD (and should be able to do it in SQL Server 2017) to control how far back in time your history will extend. Converting Existing Table ...