•  
  • Archives for May 2011 (3)

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 devices specified for backup or restore; only 64 are allowed.

Server: Msg 3013, Level 16, State 1, Line 1

RESTORE FILELIST is terminating abnormally.

 

Restore error from SQL server 2008 to SQL server 2005

Msg 3241, Level 16, State 7, Line 1

The media family on device ‘E:\mu\dba_2008.bak’ is incorrectly formed. SQL Server cannot process this media family.

Msg 3013, Level 16, State 1, Line 1

RESTORE FILELIST is terminating abnormally.

 

1. Generate Script with data 2008

2. Import/Export

Right click the database–> Tasks–> Export data–> Next–> choose the data source –>

Click next –> Finish

3. Transaction replication

I hope this article will help someone.

Muthukkumaran kaliyamoorthy

I’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server And I’m specialized in Administration and Performance tuning. I’m an active member of SQL server Central and MSDN forum. I also write articles in SQL server Central. For more Click here

More Posts - Website

Microsoft SQL Server 2008 R2 SP1

by Muthukkumaran kaliyamoorthy Published on: May 20, 2011
Comments: No Comments
Tags:
Categories:Microsoft

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

Muthukkumaran kaliyamoorthy

I’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server And I’m specialized in Administration and Performance tuning. I’m an active member of SQL server Central and MSDN forum. I also write articles in SQL server Central. For more Click here

More Posts - Website

Meme Monday: I Got 99 SQL Problems And the Disk Ain’t One

by Muthukkumaran kaliyamoorthy Published on: May 4, 2011
Comments: 4 Comments
Tags: , ,
Categories:SQL party

 

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 performed because there is no current database backup.

 

4. Poor backup strategy

No SLA for the backups (data) from the customer/Manager.

 

5. Company didn’t believe the DBAs

The important (wealth) project was not running fine. The company suddenly called a consultant even they didn’t consider the DBA but, finally the problem solved by the DBA.

 

6. Rebuilding an index run first then shrinks the database

I have seen in most of the servers a rebuild jobs run first then shrink database runs next.

 

7. Linked server issue

Often I got called from teams the linked server was not working fine. It’s return timeout error.

 

8. Poorly written queries using a Non SARG-able

 

9. No Standard operating procedures


 

 

Muthukkumaran kaliyamoorthy

I’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server And I’m specialized in Administration and Performance tuning. I’m an active member of SQL server Central and MSDN forum. I also write articles in SQL server Central. For more Click here

More Posts - Website

page 1 of 1

Welcome , today is Tuesday, May 23, 2017