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
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.
Here is mine:
1. Too many indexes on a table… Read more
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,…
INDEX DEFRAGMENTATION SCRIPT SQL 2000
Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance. When you perform any DML operation (INSERT, UPDATE, or DELETE statements) table fragmentation can occur. If you use predefined maintenance plan it will take much server resource and…
Difference between truncating and shrinking the transaction log file
I have noticed in many forum the frequently asked question is “Truncating and shrinking the log file both are same”
The answer is obviously NO. These both are totally different. Before going into discussion, let’s read the transaction log file…
T-SQL Tuesday #015: Automation:
How to setup the DB mail using Gmail account
In this article I am going to show the database mail setup steps with screen shots. When I tried to test one of my automation procedure in my friend’s laptop I got number of errors.Then I Goggled and found the solution.…
One day I got a call from my junior DBA. She asked me, how can I find out the port number for a particular server? Then our conversation started,
I asked a question to her what version of SQL server is that.
Its SQL server 2005
This article mainly for SQL server learners, who is going to become a DBA, in this article I am going to explain the backup and restore using T-SQL.
Why I choose the T-SQL instead of GUI?
Below are reasons,
I have seen a number of articles and blogs shows…
Happy moments in 2010
Hi all wish you a happy new year.
I know it’s a late post anyway I am going to share my 2010 happy moments.
My happy moments:
I have joined one of the MNC and started writing a blog, articles, reading books and following some other… Read more
Clustered index vs Non clustered index structure
Clustered and Non clustered indexes are stored in a B – tree structure .
- Clustered index enforce the logical order. (Misconception: Clustered index does not enforce the physical order)
- A table has only one clustered index because, the original table…
INDEX DEFRAGMENTATION SCRIPT for 2008 / 2005
I dedicate this article to my senior DBA “Roshan Joe Joseph” who has helped me to write a script.
I have posted the updated INDEX DEFRAGMENTATION script here, which is already published in sqlservercentral (SSC).
· I used while…
In this article, I am going to discuss about the basics of SQL server which is helpful for newbies.
Most of the people have to… Read more
I am very glad to share my experience. I have two reasons to write this article here.
First one is I had an interview with one of the company, they asked about the SQL server internals. (On that time I struggled)
When I Goggled I didn’t get entire information…