Stack Overflow
Stack Overflow

Questions tagged [recoverymodel]

13 questions
3
votes
2 answers

SQL Server: Recovery model effect on TempDB

Does the recovery model of a database effect the size of the tempdb.mdf? We have a database which involves a lot of processing and bulk inserts. We are having problems with the tempdb file growing to extremely large sizes (over 70 gb). The database…
ctrlShiftBryan
  • 27,092
  • 26
  • 73
  • 78
3
votes
1 answer

Exclude table from Database Logging

Our product contains several tables which contain custom application security info. These securityinfo tables can in some instances contain a considerable amount of rows (13 Million in one case) the tables are there to speed up queries and can…
Tim
  • 7,401
  • 13
  • 61
  • 102
2
votes
1 answer

SQL Server recovery and bulk recovery mode confusions

I have 2 confusions about SQL Server recovery and bulk recovery mode. whether recovery process itself will generate transaction log (here what I mean the logs are the logs generated by recovery process -- if any, and not generated by normal…
George2
  • 44,761
  • 110
  • 317
  • 455
1
vote
0 answers

In terms of transaction log, what is the difference between SQL Bulk Insert and SQL Insert after changing the Recovery model to Bulk Logged?

In terms of transaction log, What is the difference between 'SQL Bulk Insert' and 'SQL Insert after changing the Recovery model to Bulk Logged'?
variable
  • 8,262
  • 9
  • 95
  • 215
1
vote
1 answer

Recovery Models for SQL Anywhere

What is the equivalent to Simple/Full Recovery mode in SQL Anywhere? How do I switch between the recovery models? I have a database that I would like to change to simple recovery mode during an upgrade, so that the log file doesn't blow up, flood…
Jobs_Done
  • 35
  • 5
0
votes
2 answers

Does the Full Recovery Model Generate Additional Transaction Logs?

I read some Books Online about recovery/backup, one stupid question, if I use full database backup/full recovery model, for backup operation itself, will it generate any additional transaction log to source database server? Will full recovery…
George2
  • 44,761
  • 110
  • 317
  • 455
0
votes
2 answers

Change the Database recovery model to simple while is in production

I have a database in production and I would like to run an ETL process to DELETE some records (200 millions) of the database but since the database is in FULL model every time I try to run the ETL the Logs file get out of space. In order to avoid…
JC_BI
  • 419
  • 1
  • 5
  • 16
0
votes
0 answers

Why do I need to backup the transaction log for a point-in-time restore?

I'v read and experienced too, that in the SQL server's full recovery model, the restore to a point in time doesn't work correctly if I have only full database backups. It works correctly only if I backed up the transaction log also. But why do I…
mma
  • 381
  • 2
  • 15
0
votes
2 answers

Transactions getting slower in SQL Server

We are using full recovery model in SQL Server. We have a job which merges from a staging table to the final table. The staging table is holding millions of rows. The final table is also huge with millions of rows. We are merging in batches of…
Venkataraman R
  • 12,181
  • 2
  • 31
  • 58
0
votes
1 answer

Transaction Log Backup Chain

Database is in full recovery mode and transaction log backup job is running every 15 minutes. Will the following sequence of operations cause an issue with transaction log backups? Disable transaction log backup Take a full backup Change the…
Mayuran Parathalingam
  • 41
  • 8
0
votes
1 answer

Change recovery model while the database is in replication

We have a production database that is in full recovery mode. This database is being replicated to another server. (transaction replication) We have maintenance jobs run on Friday nights which include index rebuilding. Transaction log backup files…
Mayuran Parathalingam
  • 41
  • 8
0
votes
1 answer

Restore DB in Full recovery model when there is no backup

Suppose I want to restore a database in such circumstances: from one side there is no backup, from the other side - all the changes are stored in the log file. Can I restore the database from the log file to a specific date & time?
Geri Reshef
  • 397
  • 1
  • 6
  • 17
-1
votes
1 answer

Recommendations on which SQL Server Recovery Model to use

We have a production server which has approx. 50 customer production databases running, we are reviewing the recovery models and would like to know what all your recommendations are for what recovery model to use. I have been doing some research,…
Tyler
  • 9
  • 4