-- , 。。。
4,6
4 ,
6 , , .
--*/
select fileid,groupid,name from sysfiles where groupid=0
/*----------------------------------------
fileid groupid name
2 0 test_log
*/-- ,fileid ID,name test_log
--
1.
DUMP TRANSACTION WITH NO_LOG
2. :
BACKUP LOG WITH NO_LOG
3. ( , )
-- -- -- --
-- -- XXM, M , ,
-- -- XXM, M , ,
SQL
--
DBCC SHRINKDATABASE( )
--
backup log test with no_log
dbcc shrinkfile ('test_log',2)
or
backup log test with no_log
dbcc shrinkfile (2,2)
-- ,1 mdf,2 ldf, :
--select * from sysfiles
DBCC SHRINKFILE(1)
DBCC SHRINKFILE(2)
---------------------------------------------------------------------------------------------
4. ( sql 7.0, )
a. : -- -- -- --
b. LOG c. : -- -- -- --
LOG, 500 K
:
pubs, pubs 。
a. EXEC sp_detach_db @dbname = ' '
b.
c. EXEC sp_attach_single_file_db @dbname = ' ', @physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\ .mdf'
5. , : -- -- -- -- -- " "