SQL Backup and Restore Archives - Page 48 of 48 - SQL Authority with Pinal Dave

SQL SERVER – SQL Commandments – Suggestions, Tips, Tricks

March 20, 2007

Best Practices, Database, Software Development, SQL Backup and Restore, SQL Constraint and Keys, SQL DateTime, SQL Download, SQL Error Messages, SQL Function, SQL Index, SQL Joins, SQL Server DBCC, SQL Server Security, SQL Stored Procedure

My 20 SQL Commandments for SQL Server, rewritten from an Oracle article: know your data, test with realistic data, write identical statements, and more tips.

SQL SERVER – Restore Database Backup using SQL Script (T-SQL)

February 25, 2007

Pinal Dave

SQL Video

SQL Backup and Restore, SQL Error Messages, SQL Scripts, SQL Server, SQL Utility

Restore Database backups with a T-SQL script: read the logical file names with RESTORE FILELISTONLY, set single user mode, then run RESTORE WITH MOVE.

A barrel marked LOG overflowing with paper, and a person hesitating at the tap.

SQL SERVER – Shrinking Truncate Log File – Log Full

December 30, 2006

Pinal Dave

SQL Performance

SQL Backup and Restore, SQL Scripts, Transaction Log

The old code I used to truncate log file space with DBCC SHRINKFILE and BACKUP LOG WITH TRUNCATE_ONLY. It breaks the log chain, so take a full backup after.