SQL Server: The file growth setting is incorrect after you restore a database from SQL Server 2000 in SQL Server 2005

Who is online?  83 guests and 0 members
home  »  blogs  »  Did You Know Did You Know  »  SQL Server: The file growth setting is incorrect after you restore a database from SQL Server 2000 in SQL Server 2005

Training on Microsoft Products & Technologies

SQL Server: The file growth setting is incorrect after you restore a database from SQL Server 2000 in SQL Server 2005

change text size: A A A

posted  10/31/2011 9:33:41 AM  by Did You Know Did You Know -  Views: [851] 

This is documented in Microsoft KB article 958004. 

When you restore a database from 2000 version of SQL Server to ver 2005 (specific builds being SQL Server 2005 build 2191 or later builds of SQL Server 2005 Service Pack 1, SQL Server 2005 Service Pack 2 or later builds), you find inconsistent file growth settings.

Read more on this here: http://support.microsoft.com/kb/958004

 

@SQLServerGeeks

tags : auto grow, incorrect file growth setting, Microsoft KB article 958004, Sql server file growth bug
  Rate This Blog Entry:  register  or  login

Author

Did-You-Know Did You Know Did You Know (Member since: 7/22/2011 4:47:27 PM)

View Did You Know Did You Know 's profile

Comments (no comments yet)

Leave a comment

Name:
  *  
Email:  (your email is kept secure)
 *  
Website:

example: "http://www.SQLServerGeeks.com"

 
Type the characters:
 *
 
   

Training on Microsoft Products & Technologies

Training on Microsoft Products & Technologies

Email Subscriptions

   Get the Most Recent Blogs in your inbox
Blogs RSS Feed

Did You Know Did You Know's latest blog posts

Blogs RSS Feed

Latest community blog posts

  • SQL Server Day in Gurgaon in May 05’ 2012
    4/30/2012 5:05:54 AM by Admin Admin  - Views: 280  - Comments: 0
    Dear SQL Geek, SQLServerGeeks.com cordially invites you to SQL Server Day, the monthly dose of SQL Server knowledge & learning. And after successful events in Bangalore, Kolkata & Mumbai, we a...
  • SQL Server 2012 Feature Pack
    4/23/2012 9:24:41 AM by Quick Tip  - Views: 241  - Comments: 0
    Hi SQL Geeks, The Microsoft® SQL Server® 2012 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2012. You can download the ...
  • SQL Server QUOTENAME function
    4/23/2012 9:09:51 AM by Amit Bansal  - Views: 1158  - Comments: 4
    Hi Friends, Here is an interesting function: QUOTENAME() which returns a Unicode string with the delimiters added to make the input string a valid SQL Server delimited identifier. (from Books Online) ...
  • SQL Server 2008 R2 Express Database size limit
    4/12/2012 8:20:10 AM by Ravi Kumar  - Views: 926  - Comments: 0
    Hi All, It is a great news to all those who use SQL Server Express editions. Microsoft has increased the database size limit of SQL Server 2008 R2 Express edition from 4GB to 10GB. Previous versions o...
  • SQL Server – What is Scalar Function?
    4/11/2012 7:04:48 AM by Piyush Bajaj  - Views: 3239  - Comments: 2
    Hello Friends, It’s been a while that I have posted any blog. So here it is- Well with the arrival of SQL Server 2000, Microsoft has introduced the concept of User Defined Function (UDF). So the...
  • SQL Server 2012 Released to Manufacturing
    4/9/2012 11:41:31 AM by SQLnews SQLnews  - Views: 325  - Comments: 0
    Exciting news! SQL Server 2012 has released to manufacturing. Customers and partners can download an evaluation of the product today and can expect general availability to begin on April 1. Microsoft ...