sqlsql-serverdatabase-backupsssms
Create a backup without a transaction log
I have been given a backup of a SQL Server 2008 database in the form of a 150mb .bak file.
When I attempt to restore it to another server it attempts to secure 170gb+ of data, I am assuming this is due to a completely unreasonable transaction log size.
Unfortunately I do not have that much space on my VM to just restore it, so I have restored it on my local machine and after 3 or so hours of "100% complete, loading" it has finally restored.
So... the question is, how do I make another backup of this DB WITHOUT THE TRANSACTION LOG on SQL Server Management Studio Express 2014?
Solution
Fixed by changing the Recovery Mode to simple, dropped the 170gb transaction log to 1.5mb. Thanks @Ennor
- Delete duplicate records in SQL Server?
- SQL - Continue running all SQL statements even after error
- Retrieve result of StoredProcedure that has NO out parameter
- opposite of "top" in sql server, without using order by, there are no keys/indices
- LINQ Pivot Problem - Convert SQL Script to LINQ
- What is the difference between a primary key and a unique constraint?
- How to SELECT the last 10 rows of an SQL table which has no ID field?
- How to remove a specific character from a string, only when it is the first or last character in the string.
- extract time from now() in amazon redshift
- QL query MS Access error "field could refer to more than one table"
- How to get all auto generated foreign key names?
- Selecting data from table based on date
- SQL transaction locks query weird behavior
- PostgreSQL splitting time range into days
- How to concatenate strings of a string field in a PostgreSQL 'group by' query?
- SPARK SQL Equivalent of Qualify + Row_number statements
- Difference between CURRENT_TIMESTAMP and CURRENT_DATE
- Returning Continuous Months and Copying Values from the Previous Month
- How to drop a column from a Databricks Delta table?
- postgres. How to check if a field contains at least one substring from a list of substings?
- Oracle retrieve only number in string
- SQL ASC and DESC ordering on same column based on another column
- ANY and ALL against a small data set producing confusing results
- Generating a sequence number in a PostgreSQL database - concurrency & isolation levels
- Transact-SQL shorthand join syntax?
- How to increase the performance of a Database?
- What is the best way to create and populate a numbers table?
- What does the new stored procedure default content mean?
- Compare tkinter calendar get_date() Date with datetime field in Oracle db :
- SQL Selecting if "active" = true