SQL Data Storage Archives - Page 9 of 10 - SQL Authority with Pinal Dave

SQL SERVER – 2005 – Introduction to Partitioning

January 24, 2008

Partitioning is the database process or method where very large tables and indexes are divided in multiple smaller and manageable parts. SQL Server 2005 allows to partition tables using defined ranges and also provides management features and tools to keep partition tables in optimal performance. Tables are partition based on…

SQL SERVER – Solution – Log File Very Large – Log Full

December 16, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Log

I have been receiving following question again and again either through email or through comments on this blog. My log file is too big, what should I do? Answer to this question is in three steps. Backup the log file to any device. Truncate the log file. Shrink the log…

SQL SERVER – FIX : Error 3154: The backup set holds a backup of a database other than the existing database

September 27, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Scripts

Our Jr. DBA ran to me with this error just a few days ago while restoring the database. Error 3154: The backup set holds a backup of a database other than the existing database. Solution is very simple and not as difficult as he was thinking. He was trying to…

SQL SERVER – Fix : Error : Msg 3117, Level 16, State 4 The log or differential backup cannot be restored because no files are ready to rollforward

September 2, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Scripts

Following error occurs when tried to restored the differential backup. Fix : Error : Msg 3117, Level 16, State 4 The log or differential backup cannot be restored because no files are ready to rollforward Fix/WorkAround/Solution: This error happens when Full back up is not restored before attempting to restore…

SQL SERVER – FIX : Error : msg 2540 – The system cannot self repair this error

August 25, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Scripts

SQL SERVER – FIX : Error : msg 2540 – The system cannot self repair this error This is most annoying error. I have only faced this error twice so far. I solved this error restoring the database back up. Read here for additional help on SQL Backup And Restore.…

SQL SERVER – T-SQL Script to Attach and Detach Database

August 24, 2007

Pinal Dave

SQL Tips and Tricks

SQL Backup, SQL Data Storage, SQL Restore, SQL Scripts, SQL Server

Following script can be used to detach or attach the database. If the database is to be from one database to another database following script can be used to detach from old server and attach to a new server. Let us learn about how to Attach and Detach Database.

SQL SERVER – 2005 – SSMS – Enable Autogrowth Database Property

August 8, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Data Storage, SQL Server Management Studio, SQL Utility

We can use SSMS to Enable Autogrowth property of the Database. Right-click on Database click on Properties and click on Files. There will be column of Autogrowth, click on small box with three (…) dots. Reference : Pinal Dave (https://blog.sqlauthority.com)