Jump to content

Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

How it Works Create Account
Photo

Restore mssql database without the log perhaps?

sql

Best Answer TimothyCarr , 19 August 2015 - 01:14 PM

Technically it is possible. Could make a restoration option with truncation of not used space in the file. Try when working with low free disk space on the test server when you turn the database in... Go to the full post »


  • Please log in to reply

#1
LeovanDoorn

LeovanDoorn

    New Member

  • Member
  • Pip
  • 2 posts

Have a backup and one PC (i.e. cut off the log, and perform other manipulation is not possible). Is it possible from the. bak file when restoring to pull only the database without the log (for the last there is no place)...


  • 1

Advertisements


#2
TimothyCarr

TimothyCarr

    New Member

  • Member
  • Pip
  • 1 posts
✓  Best Answer

Technically it is possible. Could make a restoration option with truncation of not used space in the file. Try when working with low free disk space on the test server when you turn the database in there manually,  truncate the transaction log on the productions. and  only  then take a full backup  for deploy to a test server. 

Lots of help here:

  • 1

#3
LeovanDoorn

LeovanDoorn

    New Member

  • Topic Starter
  • Member
  • Pip
  • 2 posts
I am very grateful for your advice. Thank you very much! The issue has been resolved.)

  • 0






Similar Topics


Also tagged with one or more of these keywords: sql

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP