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.asp
I did the following to make the log file as small as 500Mo: Full or bulk_logged recovery model USE dbname BACKUP 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) --Optional DBCC LOGINFO --Optional Now repeate above commands as many times as needed! |
 |
|
|
|
|