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)...
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 »
#2
Posted 19 August 2015 - 01:14 PM
TimothyCarr
-
- Member
-
- 1 posts
New Member
✓ 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:
#3
Posted 19 August 2015 - 01:22 PM
LeovanDoorn
- Topic Starter
-
- Member
-
- 2 posts
New Member
I am very grateful for your advice. Thank you very much! The issue has been resolved.)
Similar Topics
Also tagged with one or more of these keywords: sql
|
Development →
Web Development →
which way is better in performance baseStarted by nikmaluavk123 , 23 Nov 2016  C#, SQl
|
|
|
|
|
|
Development →
Web Development →
Turning Excel Worksheets into a set of web-based worksheetsStarted by Cwecks12345 , 08 Jan 2016 database, sql, php, excel
|
|
|
|
|
|
Development →
Software Development →
Urgent, Please help in SQL QueriesStarted by akriti , 07 Dec 2015 SQL
|
|
|
|
|
|
Development →
Software Development →
Oracle SQL code assistanceStarted by nathanmw , 29 Sep 2015 SQL
|
|
|
|
|
Development →
Software Development →
Working with CRM's/Databases to manage Real Time DataStarted by Upilster , 09 Apr 2015 CRM, DATABASES, JAVA, SQL, PHP and 1 more...
|
|
|
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
As Featured On:
Sign In
Create Account
