We have a backup and are trying to restore this. The original database is no longer available. When we try to restore this, we get this error: System.Data.SqlClient.SqlError: There is insufficient free space on disk volume 'C:\' to create the database. The
database requires 84120371200 additional free bytes, while only 51382657024 bytes are available. (Microsoft.SqlServer.Express.Smo)
DISK and checked the contents. The problem is with the Trans log. It is too huge and guess it was allowed to grow without any restrictions. Is there any way
we can restore the backup without restoring the log? Please advice.
Thanks in advance.
View Complete Post