Viewing 5 posts - 1 through 5 (of 5 total)
check exact size of your database not right click on database then property and check size not from option.
SELECT DB_NAME(database_id) AS DatabaseName,
Name AS Logical_Name,
Physical_Name, (size*8)/1024 SizeMB
FROM sys.master_files
WHERE DB_NAME(database_id) = 'AdventureWorks'
GO
September 5, 2012 at 12:29 am
re-create indexes for those tables.
September 3, 2012 at 6:21 am
I think you configured backup with append option. So just configured new backup with default options.
-Arun
September 3, 2012 at 6:13 am
What error code are you getting?
-Arun
September 3, 2012 at 5:57 am
Can you tell what step you are performing for Rebuild Index?
September 3, 2011 at 2:13 am
Viewing 5 posts - 1 through 5 (of 5 total)