Procedure to move Microsoft SQL Server database to a new location, painlessly, if you’re running low on disk space, added a new drive array, or just curious.

How to Restore Files and Filegroups Using T-SQL. Alternatively, you can use the T-SQL commands to restore a database file or filegroup. RESTORE DATABASE [Northwind] FILE = N'Northwind' FROM DISK = N'C ...

The next step is to create a server to host your SQL database. In the Server section, click the button to Create a new Server. On the creation screen ( Figure C ), give the server a name, pick a ...

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.