Does fragmentation changes after backup/restore operation?

SQL Server Database Engine

Index ‹ SQL Server

- Previous
  - 1
    - Foreign Key Constraint issues!! There is a fundamental problem with this. Why do you want to refer to something that does not exist If you delete the user, you delete the entity to which the foreign key refers, and so the foreign key no longer has any meaning. Please clarify. This situation would normally call for cascading the delete in the relationship between Users and UserOrganizationAdded (by the way, table names should properly be in the singular because they are the name of an entity-type, the one represented in the table). The relationship, if I understand this correctly, should be this: Users 1---Many UserOrganizationAdded. In the properties of the relationship, set Cascade Deleted Records on. Then, when you delete the user, the record in the UserOrganizationAdded table will also be deleted. But something tells me that you don't want that second step to happen. Am I correct If so, then the question in my mind is Why Tag: Does fragmentation changes after backup/restore operation?
  - 2
    - Help in Query? Hi, Where did you get the id from I don't see how you have got 1,1 from the data in that table, there is no mention of the day of the week or period they teach. Some more business logic may help you get the answer you are after. Cheers Matt Tag: Does fragmentation changes after backup/restore operation?
  - 3
    - x64 version of Microsoft .NET Data Provider for mySAP Business Suite The Microsoft .NET Data Provider for mySAP Business Suite does not have an x64 version. The new .NET adapters shipped with Biztalk 2006 R2 will have support for x64 in WOW mode. Beta 1 for the the adapters is out and the SAP adapter is at http://msdn2.microsoft.com/en-us/library/aa561012.aspx The new adapters also support ADO.NET connectivity - so you can use SSIS. Tag: Does fragmentation changes after backup/restore operation?
  - 4
    - How do I automate removal of reports? Define "everything" Why can't you just use different connection strings If the issue is just deploying the same reports to dev/uat/production etc. then just use config mgr. Tag: Does fragmentation changes after backup/restore operation?
  - 5
    - User credentials delegation from IIS on WinXP to SQL Server on Win2003SRV fails Did you disable the anonymous logon in the IIS settings If this is enabled it will be prefered over all other settings. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Tag: Does fragmentation changes after backup/restore operation?
  - 6
    - Running SSIS package (.dtsx) from a ASP.Net web service Hi Rob, There is books online entry that gives an example of how to do this. http://msdn2.microsoft.com/en-us/library/ms403355.aspx Also note the comments in the Community Content at the bottom. It has some important notes about security and thread impersonation. ~Matt Tag: Does fragmentation changes after backup/restore operation?
  - 7
    - ExecuteNonQuery hangs in Timer event notification A-hah! It's not hanging; it's just throwing an exception that the runtime itself catches, then doesn't report. Tag: Does fragmentation changes after backup/restore operation?
  - 8
    - Cannot get access to my Access 2003 database tables Hi, if you are using an access database, you probably should address your question to an access forum. use the MS public access forum to find adqueate answers. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Tag: Does fragmentation changes after backup/restore operation?
  - 9
    - Combine two stored procedure results Can you change getdata (or is this something your stuck with ) Another possible option is to turn your getdata stored procedure into a table valued function. This means you won't be able to exec it directly though, you will have to access it in a query. Then you could do: select * from db2006.dbo.getdata(...) union select * from db2005.dbo.getdata(...). This would most likely perform better (although I can't say for sure). If getdata() is one query (or can be turned into one query), then you can use an inline table valued function, and this will definitely perform better then the temp table solution. Also, your probably better off using a table variable in this case as opposed to a temp table. Tag: Does fragmentation changes after backup/restore operation?
  - 10
    - soap message exchange between .NET Webservice and stored procedure I don't fully understand the question, but in SQL 2005 you can use a CLR based stored proc to call into a .NET web-service. Niels Tag: Does fragmentation changes after backup/restore operation?
  - 11
    - Shared Connections and Stored Credentials for Subscriptions? Hello Dick, What kind of errors/problems are you seeing You should be able to create a shared data source (of course, with stored credentials), then be able to create a subscription on that report. From Report Manager, create a new data source, and store the credentials in it. Modify the connection to one of your reports to use this connection, then create a subscription. It should work then. Jarret Tag: Does fragmentation changes after backup/restore operation?
  - 12
    - T-SQL / varchar truncate solutions First of all this would fail if it was an INSERT or UPDATE with the error "String or binary data would be truncated". The Books Online state: "ANSI_WARNINGS is not honored when passing parameters in a stored procedure, user-defined function, or when declaring and setting variables in a batch statement. For example, if a variable is defined as char(3) , and then set to a value larger than three characters, the data is truncated to the defined size and the INSERT or UPDATE statement succeeds." I would rather have an architecture that prevents this situation from happening instead of choosing my database vendor based on this minor issue. There are a million reasons to choose for a specific database product and I find it hard to comprehend that this would be THE reason for choosing a specific database vendor. WesleyB Visit my SQL Server weblog @ http://dis4ea.blogspot.com Tag: Does fragmentation changes after backup/restore operation?
  - 13
    - Data Flow Task Stuck Are the source connections pointing to the same database I'm not familiar with Unidata, but it sounds like there might be some type of blocking issue, either in the database or in the ODBC driver. If you use two separate data flows, one per DataReader Source, does it consistently run successfully Tag: Does fragmentation changes after backup/restore operation?
  - 14
    - Reporting Services Preview View different from Print Layout I'm currently using Sql server 2005 Reporting Services. I'm trying to take data and fill in a form that I'm making a background image. When I go to preview all the textboxes filled with data align with the fields in the background image form. When I go to print they are off by a inch or so horizontally. Can anyone help me on this topic. Tag: Does fragmentation changes after backup/restore operation?
  - 15
    - Delete row where a particular field value is not in a list Crazy method for identifing file extension: declare @filename varchar ( 100 ) set @filename = 'filename.txt' select charindex ( '.' , @filename ,- 1 ) --Position of last dot in @filename select substring ( @filename , charindex ( '.' , @filename ,- 1 ), len ( @filename )- charindex ( '.' , @filename ,- 1 )+ 1 ) --result '.txt' Than you could use "IN keyword" PS. With query works very slow Tag: Does fragmentation changes after backup/restore operation?
  - 16
    - SSRS Performance Hi All, I am facing an issue while working with huge data in tables. I have a stored procedure which when exceuted on SQL Server Browser takes little time to display the output on the screen. The same stored procedure is used by the application with SQL Server Reporting Services to generate the report. When executed, the application stops responding after sometime. After debugging steps by steps, I found that the dataset fetches the records from database using stored procedure takes around 11 mins and application stops responding while generating the reports. Now, does this happens with some performance related issue with SQL Server Reporting Services or Do I need to modify stored procedure Tag: Does fragmentation changes after backup/restore operation?
- Next
  - 1
    - sp_spaceused equivalent in CE? sp_spaceused is not available in SQL Compact. You may find this useful: http://support.microsoft.com/kb/827968/en-us Tag: Does fragmentation changes after backup/restore operation?
  - 2
    - Wat's the effective way to improve performance in table using indexing? Well, that depends. As data is continously appended to the table in a date increasing manner and old data is not deleted, you should consider using a clustered index with a high fill factor. Could you explain the pupose and the lifetime of the transaction table HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Tag: Does fragmentation changes after backup/restore operation?
  - 3
    - How to verify installed license Hi, SELECT CONVERT(char(20), SERVERPROPERTY('LicenseType')) SELECT CONVERT(char(20), SERVERPROPERTY('NumLicenses')) HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Tag: Does fragmentation changes after backup/restore operation?
  - 4
    - How to rename a column or table on the desktop? A 3rd party tool from this company may be able to help you, please contact the company (I am not affiliated): http://www.primeworks-mobile.com/ Tag: Does fragmentation changes after backup/restore operation?
  - 5
    - CAB Files The cab file contents are documented here: http://www.microsoft.com/sql/editions/sqlmobile/installsdk.mspx Tag: Does fragmentation changes after backup/restore operation?
  - 6
    - Executing an SSIS package containing Analysis Services from ASP.NET Surely someone has had to do this before Tag: Does fragmentation changes after backup/restore operation?
  - 7
    - Upgrade SQL 2005 Standard to SQL 2005 Enterprise Andy, Yes SQL Server 2005 Standard can be upgraded to SQL Server 2005 Enterprise. Remember after the upgrade you will need to reapply any hot fixes and service packs. http://msdn2.microsoft.com/en-us/library/ms143393.aspx Hope this helps Michael Tag: Does fragmentation changes after backup/restore operation?
  - 8
    - SQL Reporting Services performance on navigation pages. SSRS always performs database caching (aka user sessions) by saving the report intermediate format in the report database. This is why subsequent calls to the report using the same parameters are very fast. The SessionTimeout setting in the ConfigurationInfo table in the ReportServer database controls the lifetime of the user sessions. I suggest you take a look at the ExecutionLog table as a first stop to troubleshooting performance issues. It will tell you how much time the Report Server spents in data retrieval, processing, and rendering the report. Tag: Does fragmentation changes after backup/restore operation?
  - 9
    - Determine if a column is indexed (and the index name) Which version of SS are you using To select all indexes where the column is part of the key, in 2005, you can use: select object_name ( si . [object_id] ) as table_name , si . name as index_name , index_col ( object_name ( sic . [object_id] ), sic . index_id , sic . index_column_id ) as column_name , sic . key_ordinal , sic . is_descending_key , sic . is_included_column from sys.indexes as si inner join sys.index_columns as sic on si . [object_id] = sic . [object_id] and si . index_id = sic . index_id where si . object_id = object_id ( 'dbo.Employees' ) and columnproperty ( object_id ( 'dbo.Employees' ), 'LastName' , 'ColumnId' ) = sic . column_id order by sic . [object_id] , sic . index_id go AMB Tag: Does fragmentation changes after backup/restore operation?
  - 10
    - Personalize Reports for Each User Try User!UserID. Tag: Does fragmentation changes after backup/restore operation?
  - 11
    - excel data mining add-in for categorical data We discovered this issue and it will be addressed in a future release but currently there is no workaround for this problem using BI Dev Studio. Here is an alternate way of doing the same thing: - in Excel, under the Data mining tab, select the "Advanced\Add model to mining structure" option - create a new model using whatever algorithm (Clustering, I assume) and setting any parameters you might want. The wizard will create a new model inside the same structure and process it. If having multiple models does not bother your, you can leave them all inside the structure. Otherwise, you can delete the old models using the Manage Models option in the Data Mining tab. Also, after executing the steps you mentioned in the BI Dev Studio, chances are that your mining structure is in an incosistent state. You can restore its original (processed) state by invoking, under Manage Models, Process structure with new data then point to the data source you used in creating the structure the first time Hope this helps Tag: Does fragmentation changes after backup/restore operation?
  - 12
    - HOW TO DELETE OLD BACK UP FILES AND TRANSACTION LOGS IN SQL 2005 The Maintenance Cleanup task removes files related to maintenance plans, including database backup files and reports created by maintenance plans. Tag: Does fragmentation changes after backup/restore operation?
  - 13
    - Embedded image does not appear Some new informations: The imported image is an printable image with 300 dpi. These image does not appear in the report. Another image, 72dpi, appears. Is it possible, that the render is not able to render 300 dpi Tag: Does fragmentation changes after backup/restore operation?
  - 14
    - can't (re)start SQLServerAgent after changing its logon credentials If you change the account under which SQL Agent starts you need to make sure that the account has permissions within SQL server or else each tim eit tries to access SQL Server it will fail. Have a look at these: http://support.microsoft.com/kb/283811 http://support.microsoft.com/kb/907557 Tag: Does fragmentation changes after backup/restore operation?
  - 15
    - I have a VB script that works in WinXP sp1 but not in WinXp sp2 Would this post be served better at a different forum Tag: Does fragmentation changes after backup/restore operation?
  - 16
    - Correlated subquery in UPDATE - Where am I going wrong? Hi, You can rewrite the query like this: UPDATE TABLE1 SET COL_A = T2 . COL_A , COL_B = T2 . COL_B FROM TABLE1 AS T1 INNER JOIN ( SELECT TOP 1 COL_A , COL_B , COL_C FROM TABLE2 ) T2 ON T2 . COL_C = T1 . COL_C WHERE T1 . COL_A IS NULL What is the exact purpose of the query cause it seems a little bit strange. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog Tag: Does fragmentation changes after backup/restore operation?

Liquidloop

Hello,

If i backup a database and then restore it, would physical structure remain the same specially fragmentation.

I'm concerned about output of DBCC SHOWCONTIG.

Senario: I want to check if client database needs defragmentation, so he's sending db backup file. But is it possible that when i restore it fragmentation info has got lost

Thank you.

STG Labs

Top

Re: Does fragmentation changes after backup/restore operation?

Peter Byrne MSFT

Table/index fragmentation should be unaffected by BACKUP/RESTORE.

Top

Re: Does fragmentation changes after backup/restore operation?

Liquidloop

And i hope it's same for tranferring .mdf file to be attached later

Top

Re: Does fragmentation changes after backup/restore operation?

Peter Byrne MSFT

Yes, it is the same for detach/attach.

Top