In this post I am going to explain the importance of recovery models and backup types. Why I am writing this post ? Because, when I was teaching about the topic to my PHP friend .He got doubts on bulk logged recovery model and differential backups. I have given some examples and cleared his doubts. I am going to share this with you guys too. I hope this will help for Freshers and DBA managers. Recovery models and backup types are important to plan the recovery point objective (RPO) and recovery time objective (RTO). We can’t differentiate the recovery models and backup types. Simply, it’s a mixture. Let’s see the discussion. Manager: We need minimum data…
-
-
Restoring a database from higher version to lower version SQL server
Restoring a database from higher version to lower version SQL server How to downgrade a database from higher version to lower version? There is no direct way to do this like Backup/Restore. You can use an alternative ways. The alternative ways are, 1. Generate Script 2. Import/Export 3. Transaction replication You may use the alternative ways. It depends upon your environment. Restore errors A backup has taken from higher version (SQL 2008/2005) BACKUP DATABASE dba_test TO DISK='E:\mu\dba_2008.bak' Restore the backup to lower version (SQL 2005/2000) RESTORE FILELISTONLY FROM DISK ='E:\mu\dba_2008.bak' Restore error from SQL server 2005 to SQL server 2000 Server: Msg 3205, Level 16, State 2, Line 1 Too many backup…
-
Microsoft SQL Server 2008 R2 SP1
Microsoft SQL Server 2008 R2 SP1 CTP SQL Server 2008 R2 SP1 10.50.2418.0 CTP is available now. You may download and test it. http://www.microsoft.com/downloads/en/details.aspx?FamilyID=15dcfec2-abb8-409d-91ff-c7c8e18c8409 hacklink panel hacklink al seo paneli hacklink iqos haclink hacklink
-
Meme Monday: I Got 99 SQL Problems And the Disk Ain’t One
Meme Monday: I Got 99 SQL Problems and the Disk Ain’t One I am a bit late to this party. I have seen this post from Grant’s blog now only. Thanks to Thomas LaRock such a great topic. Here is mine: 1. Too many indexes on a table Developers didn’t check their codes and an execution plan too. They just go and create the indexes (Duplicate indexes too). 2. Improper memory setting Improper min, max memory setting especially for 64-bit servers. 3. Improperly configured transaction log Whenever I got a new server, I have seen log backups are failing because, there is no current database backup. BACKUP LOG cannot be…
-
Shrinking the log file script for SQL server database
Shrinking the log file script for SQL server database This script mainly for a DBA’s, because most of the time the log file grow again and again and eats up all the disk space and finally an application goes down. Errors from SQL server error log: Error: 9002, Severity: 17, State: 2. The transaction log for database ‘test’ is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases If you got an error “Error: 9002, Severity: 17, State: 2.” like this go and check the log_reuse_wait_desc column in sys.databases by running below command and see what value it returns. SELECT name,…