1) Can I run DBBC SHRINKDATABASE command with users connected to the database to be shrunk?
2) Any problem with data? Do I need to take a back up before running DBBC SHRINKDATABASE?
3) If I don’t have the options NOTRUNCATE/TRUNCATEONLY and I simply run:
DBCC SHRINKDATABASE (mydatabase, 10)
what happens to the files and data?