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 |
|
leama
Starting Member
2 Posts |
 Posted - 2015-02-12 : 09:09:05
|
| Hello,As you see in the title, I can not restore a 1.7Go data base, an error message says that I need more than 27Go on disk while I have only 5Go.Have you any idea if this is normal? By the way, I restored a 0,7Go data base instead and it worked fine.Thanks!Lea |
|
|
leama
Starting Member
2 Posts |
Posted - 2015-02-16 : 06:31:43
|
| I have found the reason after restoring it on another machine which has 30Go free. It is the large LDF file taking more than 25Go. I did some research on LDF file and found this article helpful:http://www.karaszi.com/sqlserver/info_large_transaction_log_file.aspI did the following to make the log file as small as 500Mo:Full or bulk_logged recovery modelUSE dbnameBACKUP LOG dbname TO DISK = 'C:\x\dbname.trn'--First param below is fileno for log file, often 2. Check with sys.database_files--Second is desired size, in MB.DBCC SHRINKFILE(2, 500)DBCC SQLPERF(LOGSPACE) --OptionalDBCC LOGINFO --Optional Now repeate above commands as many times as needed! |
 |
|
|
|
|
|
Restore a 1.7Go data base needs 27Go space?