I have a large database on sql server 2005. After shrinking the data file, the database is still very big: around 9 GB.
Here is some data from sp_spaceused:
exec [dbname].dbo.sp_spaceused reserved |data kb |index_size |unused | 10221976 KB |849240 KB |9367456 KB |5280 KB |
can I use
DBCC SHRINKFILE(logic_name_dat, 1000(Mb))
without losing user data on that database?