-
as seen on Stack Overflow
- Search for 'Stack Overflow'
What are the advantages and disadvantages of shrinking a database? Are there any performance implications?
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
We have a need to fit database in 4G in order to use ms sql express edition.
I started from 7G database, and found a lot of not needed records, and deleted them.
After Shrink database size is 4.6G, and 748MB is free (according to database properties).
However, when i execute
exec sp_spaceused i…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
How is it possible to execute a direct SQL command to an ADO.NET connected database?
I want to send a DBCC SHRINKDATABASE to the SQL server, to compress the current datafile after a big deletion process. The function ObjectContext::CreateQuery returns a parser error after the DBCC command. Is there…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
My question is, should I be running one or both of the shrink command regularly,
DBCC SHRINKDATABASE
OR
DBCC SHRINKFILE
=============================
background
Sql Server: Database is 200 gigs, logs are 150 gigs.
running this command
SELECT name ,size/128.0 -
CAST(FILEPROPERTY(name,…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi I'm having a production database and its replicated report database. How to shrink the transaction log files in the production database as the log file size is increasing. I had tried DBCC SHRINKFILE and SHRINKDATABASE commands but it does not work for me. I can't detach and shrink and attach…
>>> More
