Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
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