July 23, 2003 at 10:02 am
First to run sp_spaceused @updateusage = true to find out spaces used by your database and sp_helpfile to get how large your MDF and LDF are. Then shrink them with DBCC SHRINKFILE command.
Which verion of SQL Server do you run?
Edited by - Allen_Cui on 07/23/2003 10:03:31 AM
Edited by - Allen_Cui on 07/23/2003 10:04:48 AM
July 23, 2003 at 1:13 pm
Expanding your database from 1MB to 50GB take long time. Who many data files you have? Make sure you have enough disk space left on the drives where your data file/files reside
Shas3
July 24, 2003 at 12:37 am
Hi again ...
Firstly, thank you for the responses.
I am running SQL2000 ADV SERV with SP3. There is just one .mdf and one .ldf to this database. The available drive space is in excess 200GB. The drive configuration is RAID 5.
Shas3------------------------------------
Expanding your database from 1MB to 50GB take long time. Who many data files you have? Make sure you have enough disk space left on the drives where your data file/files reside
------------------------------------------
How long should one expect this process of expanding the files to take? Previously I tried a restore directly to the newly created db with files of 1MB and that just took hours and I had to kill it. Therefore I decided that maybe resizing the data files or createing the db with large data files may speed up the process.
Thanks
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply