数据库出现的问题及解决方法（Database problems and Solutions）.docVIP

数据库出现的问题及解决方法（Database problems and Solutions） How to solve common problems, ------------------------------------------ database 1: separating Database Enterprise Manager server Database right key separating database 2: delete the LOG file 3: additional Database Enterprise Manager server Database right + additional database This method generates a new LOG, with a size of only more than 500 K, then sets the database automatically Or code: The following example isolates pubs, and then attaches one of the files in pubs to the current server. EXEC, sp_detach_db, @dbname =pubs EXEC, sp_attach_single_file_db, @dbname =pubs, @physname =c:\Program, Files\Microsoft, SQL, Server\MSSQL\Data\pubs.mdf 2: empty logs DUMP TRANSACTION WITH NO_LOG libname Again: Enterprise Manager - right you want to compress the database -- all tasks -- contraction contraction file - select the database log file - select the contraction to XXM in contraction mode, this will give a shrink to the minimum allowed direct input M number, this number can be determined 3: if you dont want it to grow in the future Enterprise manager server Database attribute transaction log , the file growth is limited to 2M - Compressed log 1: truncate transaction logs: BACKUP LOG database name WITH NO_LOG 2: empty logs DUMP TRANSACTION WITH NO_LOG libname Again: Enterprise Manager - right you want to compress the database -- all tasks -- contraction contraction file - select the database log file - select the contraction to XXM in contraction mode, this will give a shrink to the minimum allowed direct input M number, this number can be determined 3: deletes LOG 1: separating Database Enterprise Manager server Database right key separating database 2: delete the LOG file 3: additional Database Enterprise Manager server Database right + additional database This method generates a new LOG, with a size of only more than 500 K, then sets the database automatically Or code: The following example isolates p