Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Shrink Database Rss

   Items 1 to 10 of 10   
 

Shrink Database

By bitbucket-25253 2011/08/10 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,863 reads

SQL Q&A: Shrinking, Growing and Redesigning Databases

SQL databases come in all shapes and sizes and schemas. This month, our SQL expert helps with condensing, growing and redesigning databases.  Read more...
By Additional Articles 2010/08/06 | Source: TechNet Blogs | Category: administration
Rating:  Rate this |   Briefcase | 3,922 reads

Issues with running DBCC SHRINKFILE on your data files

Why would database performance remain low and fragmentation high event though the entire database has been defragmented every night? In this tip we cover how SHRINKFILE works and some of the issues it might create.  Read more...
By Additional Articles 2010/07/27 | Source: MSSQLTips.com | Category: administration
Rating:  Rate this |   Briefcase | 4,526 reads

Grow\Shrink all datafiles SQL 2005\2008

Generates a script to grow\shrink all datafiles for a database to the same amount  Read more...
By Allan Roodt 2010/07/23 | Source: SQLServerCentral.com | Category: shrink database
Rating: |  Discuss |   Briefcase | 2,224 reads

Automate scripting of database file shrink

I have a large number of databases that I can free up significant space, but to avoid resource conflict,   Read more...
By Jason S Wong 2009/11/09 | Source: SQLServerCentral.com | Category: shrink database
Rating: |  Discuss |   Briefcase | 2,296 reads

Automate scripting of database file shrink

I have a large number of databases that I can free up significant space, but to avoid resource conflict,   Read more...
By Jason S Wong 2009/11/09 | Source: SQLServerCentral.com | Category: shrink database
Rating: |  Discuss |   Briefcase | 2,296 reads

Shrinking the Log

It seems that I see more and more posts about people trying to shrink their transaction logs. It's getting to be close to the time when I need a cut-and-paste snippet stored in a file I can pull out for my standard "it is recommended that you...  Read more...
By Steve Jones 2009/07/13 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,870 reads

Can you shrink your transaction log files to death?

can undermine server performance. An expert runs various tests to determine how transaction log file size responds to various T-SQL commands.  Read more...
By Additional Articles 2009/02/23 | Source: SearchSQLServer | Category: transaction logs
Rating: (not yet rated)  Rate this |   Briefcase | 3,024 reads

Can you shrink your SQL Server database to death?

To increase SQL Server disk space, 'shrink the database' task is used. But the tests in this tip using autogrowth prove that 'shrink database' poorly impacts SQL performance.  Read more...
By Additional Articles 2008/10/14 | Source: SearchSQLServer | Category: administration
Rating:  Rate this |   Briefcase | 3,901 reads

Shrinking all log files (or data files) on SQL Server 2005

This is a small script to clean and shrink all online logs on SQL Server 2005. Run it as a job or manually.  Read more...
By stalley-gordon 2008/08/21 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 2,190 reads
   Items 1 to 10 of 10   
 
Tags
administration (6)    
blogs (1)    
dbcc (1)    
log file (1)    
performance tuning (1)    
shrink (1)    
sql server 2005 (1)    
transaction logs (1)