DBfile usage

DBfile usage,Sql server,Sql

Thursday, March 29, 2012

DBCC SHRINKFILE ('filename' , EMPTYFILE) not working

›
I created a file (size = 1 GB, filegrowth=1 GB) but I forgot to add it to the correct filegroup (it defaulted to the primary). I am trying t...

DBCC SHRINKFILE ('filename' , EMPTYFILE) not working

›
I created a file (size = 1 GB, filegrowth=1 GB) but I forgot to add it to th e correct filegroup (it defaulted to the primary). I am trying ...

dbcc shrinkfile & recovery mode

›
Occasionally, we have gotten messages that the logfile is too big on one of our servers. At that point, we will run a backup of the database...

dbcc shrinkfile & recovery mode

›
Occasionally, we have gotten messages that the logfile is too big on one of our servers. At that point, we will run a backup of the database...

dbcc shrinkfile & recovery mode

›
Occasionally, we have gotten messages that the logfile is too big on one of our servers. At that point, we will run a backup of the databas...

dbcc shrinkfile - SQL Server 2000 - invalidate log?

›
Hi, I need to shrink a database file and was wondering whether it is required to run a full backup after the shrink operation. In SQL Server...

dbcc shrinkfile - how long will it take

›
Hi, We are shrinking a large databse using dbcc shrinkfile and it has been running for hours. Is there any way of determining how long the j...
›
Home
View web version

About Me

sco
View my complete profile
Powered by Blogger.