Blogspot - sql-server-recovery.blogspot.com - SQL Server Recovery Blog
General Information:
Latest News:
Recover Lost Data using Database snapshot in SQL Server 28 Mar 2013 | 08:28 am
Databasesnapshot was firstly introduced in SQL server 2005 enterprise edition. It is a static view of SQL server database (source database) and read-only in nature. It resides on the same instance as ...
How to Creare a SQL server database with .MDF file only? 18 Mar 2013 | 12:44 pm
Are you new in SQL server and trying to create a new database for test or study purpose? Then you can do this with the help of mdf file only. MDF file is the primary database file of the SQL server. I...
Reason & Resolution steps for SQL server error 233 7 Feb 2013 | 03:32 pm
Are you getting below error message while connecting to the Microsoft SQL server? If 'Yes' then don't worry!! You have reached at the right place. After getting any error message; first of all check...
Is your SQL server database backup OK? Check it now 29 Jan 2013 | 02:30 pm
A data can be any thing like employee attendance record, student marks detail, passenger list, customer list, booking history, and so on. Normally data backup is taken by database administrator but if...
Unable to Restore SQL Database Backup: error 3205 15 Jan 2013 | 02:38 pm
When you try to restore a SQL server database backup created on SQL server 2005 instance to a different SQL server instance using SQL server management studio (SSMS), you may get following error messa...
What is the Recovery Model for Newly Created Database? 27 Dec 2012 | 03:27 pm
SQL server offers a facility to all database administrator for managing transaction log that is known as Recovery model. It will decide that you are going to manage your transaction log or not. There ...
Getting Started with SQL Server Transaction Log 21 Dec 2012 | 09:21 am
SQL server transaction log records of all the changes made on the database while the actual records are placed in a separate file. This file is known as transaction log file and the file extension for...
Top 5 Disaster Recovery Solutions in SQL Server 27 Nov 2012 | 01:16 pm
Hey Guys!! How are you? I hope that you all are doing well. As we all know disaster can strike on the database in any form & any time. So it is better to well prepared to get rid from it. There are so...
SQL Server Backup & Reduce Time to Accomplish a Backup 23 Nov 2012 | 11:33 am
As we all are aware that backup of data is essential for reducing the change of data loss due to failure and SQL server is not an exception. SQL server backup is helpful in restore & recovery of loss ...
How to Resolve SQL Server Error 5172? 31 Oct 2012 | 08:13 am
Sometimes when you tried to re-attach a SQL server database, you may get error message “5172:The header for file 'databaselog.ldf' is not a valid database file header. The Page Audit property is incor...
