can i srink msdb sys database using dbcc , is there any affect to the production server (which is running currently) or any other production databases. please respond
View Complete Post
I have a SharePoint content database with the size 70GB but he log file is 450GB. i wanted to shrink the log file. Can anyone tell me how to do that ? It would be great if anyone can provide me the complete flow.
This is all on the production server, i need to fix this asap. Any help would be appreciated.
Thanks in Advance.
Hello All !
I want to know if there are differences between "Autoshrink" database option and the SQL DBCC shrink (database/file) command.
I have, in production environment, a MS application (MIIS) with a SQL 2005 DB. This application takes very large db files (logs and datas). It's absolutely normal (several millions of transactions by day)
However, I had this morning a problem with disk space.
If I run manual dbcc shrink (db / file): I recover 4 GB
If I set "Autoshrink" option: I recover 50 GB
Microsoft doesn't recommand to set the "autoshrink" option on the majority of databases (for performances problems)
Are there links about these differences ?
I have a 90GB ContentDB, that was full of 1000's of infopath forms... I have deleted all the forms, and the database remains the same size, and when I go to shrink the database it says no free space is available in SQL Server Management Studio.
Do I have to wait for the recycle bin retention date to kick in, regardless of having deleted the data from BOTH the end user and site collection recycle bins?
I really need to get the size of the database down before backing it up and moving the site collection.
i have merge replication configured on sql 2008. HOw i should shrink log file of replicated database.
I am getting the following error when I execute an SSRS report.
The EXECUTE permission was denied on the object 'sp_start_job', database 'msdb', schema 'dbo'.
The report is executing a stored proc. Which in turn is running an Agent Job.
When I run this report through BIDS it works fine. It is only when I run it though Report Manager I get a problem.
Can anybody help?
I have a few TFS databases and the transaction log files have grown to 40-50GBs. I manually ran full transaction log backups, and the log files now have 1-3MB of data. I tried to shrink the files. Some of the transaction log files shrunk only a couple gigabytes,
and a few didnt shrink at all. Is there something I could do to make these files shrink to a couple gigabytes.
I do like to find the query to list out all the available database role membership identities for msdb database. For other database i pull out the list of database role membership from sys.database_principals whose
principal_id ranges between 16384-16393. For msdb database there seems to be much of database roles and it is not available in sys.database_principals. Kindly help me out in pulling out all the database roles for msdb database alone.
I have productive database on mirror. The mirror in asynchronous mode. On principal server the log file have size 95Gb. I want to shink log files. Can i shink this log files, or a get problems if i tray do whis?
Thanks a lot!