Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gavis
Starting Member
39 Posts |
 Posted - 2008-10-24 : 03:55:49
|
| unable to shink db in sql(2000) or via a script,msg of it been successful but the size is still unchanged, even with the tick on with "move pages to beginning". available space over 25gbsdrive is full to capacity. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-10-24 : 04:09:10
|
Are you sure it's the data file that is big?How about log file?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
gavis
Starting Member
39 Posts |
Posted - 2008-10-24 : 05:03:38
|
| yes it was the datafile, got it working after pulling all my hair off.to my understanding if the services were restarted the space avail would return to sql.but it didnt work,so i stopped all the services for sql, restarted the server, came up into windows with service running,restarted the services again and refreshed sql. then BOB'S my uncle. it worked. Is this a sql 2000 defect? i couldn't understand why the shrinking didn't work? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-10-24 : 05:27:04
|
Then the problem was NOT the datafile.It must have been either the tempdb or log file.Data files do not shrink when restarted.Please do a full backup of your database in case you have broken the backup chain.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2008-10-24 : 09:21:53
|
| Did you run sp_spaceused to see unused space in database you want to shrink. |
|
|
|
|
|
|
urgent help needed