SQL Server Backup Types New! Welcome to this new series of columns for working with SQL Server. First, let's talk backups. By Eric Johnson 10/08/2007 Welcome to this new series -- in this column, I ...

A file explorer window appears. Navigate to the BAK file, select it, and click "Open" to add the file to the backup medium. Click "OK," then click "OK" again to open the file for backup.

Net-admin types appear to prefer the agent-based backup. And the developers I've spoken with like the idea of programming it. <BR><BR>Being a net-admin type, the Veritas-SQL-agent looks nice.

As a test, I created a test share on the C: drive of Server2 instead of the USB data drive and I have no problems with SQL 2008 or 2005 reading the backup files I copy there from the new DFS alias.

FROM sys.database_files WHERE type_desc = ‘LOG’ Once I have my log file name, I can use the DBCC command to shrink the file. In the following command I try to shrink my log file down to 1GB.