This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
SQL Server Database Log File Grew Too Big.

SQL SERVER – master Database Log File Grew Too Big

January 9, 2011
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts

A reader found the master database log file grew very large even in simple recovery mode. I share the full email and ask what you would suggest.

Read More
Four figures seen from behind carrying one long oak beam on their shoulders along a village lane.

Striped Backups: Writing One Backup to Several Files

January 6, 2011
Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Server

Use striped backups across several files, inspect media families, restore every stripe, and test resource settings on your own server.

Read More
Two wooden house-shaped blocks with keyholes stand beside two plain metal keys on a table.

Restoring to a Newer SQL Server Is a One-Way Trip

December 24, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Backup and Restore, SQL Server

Plan a restore to newer SQL Server with the version boundary in mind, preserve the original backup, and understand options for moving data back.

Read More
A hand moving tiny furniture from an old dollhouse into the matching rooms of a new one

Restoring a Sample Database to New Folders With RESTORE FILELISTONLY

December 8, 2010
Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Sample Database, SQL Scripts

Use RESTORE FILELISTONLY to map backup files to local folders, restore a separate sample copy, and verify its data and log paths.

Read More
Database name backup start date.

SQL SERVER – Get Database Backup History for a Single Database

November 10, 2010
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts

A reader script by aasim abdullah to get database backup history for a single database: backup file, size, time taken, LSNs and the type of each backup.

Read More
An open protected archive case sits before shelves of closed cases ready for inspection.

SQL SERVER – Finding Last Backup Time for All Database

November 4, 2010
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL DMV, SQL Scripts, SQL Server

Last Backup Time comes from recorded history, which I check by backup type. Recovery still needs the files and a tested chain.

Read More
Database backup process.

SQL SERVER – Corrupted Backup File and Unsuccessful Restore

October 24, 2010
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Error Messages

Called in to tune an OLTP server, I ended up helping a Jr. DBA whose restore kept failing. Here is the story of that corrupted backup file.

Read More
Previous 1 … 36 37 38 39 40 41 42 … 51 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com