Board index » MS SQL Server

All times are UTC



 Can you shrink a Database Device in SS 6.5 
Author Message
Barry McAusli
#1 / 2
 Can you shrink a Database Device in SS 6.5
Can you shrink a Database Device in SQL Server 6.5?  If so what is the TSQL
command.

Thanks in advance.
--
Barry McAuslin MCSE



Sat, 13 Apr 2002 03:00:00 GMT
Tibor Karasz
#2 / 2
 Can you shrink a Database Device in SS 6.5

Barry,

No, you cannot do that, DUMP and LOAD is the only workaround (which doesn't
shrink the file at all).

--
Tibor Karaszi
MCDBA, MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB
Please reply to the newsgroup only, not by email.


Quote:
> Can you shrink a Database Device in SQL Server 6.5?  If so what is the
TSQL
> command.

> Thanks in advance.
> --
> Barry McAuslin MCSE



Sat, 13 Apr 2002 03:00:00 GMT
 
 Page 1 of 1
  [ 2 post ] 

 Relevant Pages 

1. Shrinking database devices in SQL Server 6.5

2. Shrink SQL Server 6.5 Database Device

3. How to shrink device in MSSqlServer 6.5

4. Shrinking a 6.5 Device

5. How to shrink the Database size and Database Device size

6. SS 6.5 problem creating database for load

7. Help Shrinking Database Device!

8. Shrinking Database devices

9. How to shrink Master database device

10. Help Shrinking a DataBase Device.

11. Database Device shrinking

12. Database device shrinking

 
Powered by phpBB® Forum Software