Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

@gbn ,Im building a hash / scramble mechanism which takes a bak - hash it - and saves it. I really dont need to deal with the LDF here...
–
Royi NamirDec 29 '11 at 13:29

I dont understand why this question was downrated . it is a valid question. if its bad practice - so the action is to responde why is it bad practice and not to downvote.... people dont know the meaning of downvote here...@marc_s ... was that you ? :)
–
Royi NamirDec 29 '11 at 13:34

1

So are you trying to do your own back up solution? BTW I didn't downvote
–
gbnDec 29 '11 at 13:35

1 Answer
1

But if you have more than 10240 Mb of data in MDF file - it woun't help, then you have to add extra file to DB - where to move extra data from MDF file.

From BOL:

DBCC SHRINKFILE

Shrinks the size of the specified data or log file for the current database or empties a file by moving the data from the specified file
to other files in the same filegroup, allowing the file to be removed
from the database. You can shrink a file to a size that is less than
the size specified when it was created. This resets the minimum file
size to the new value.

How to know filenames in DB:

SELECT file_Id, name FROM sys.database_files

Shrinking data files always affects performance - it makes it worse, so you really need to have a REASON to do that.