Tagged Questions
2
votes
1answer
200 views
Restore transaction log backup - media family error
Our backup procedure is as follows: midnight full backup, every 8 hour differential backups, and every 5 minutes transaction log backups. Maintenance plans keep everything rolling and tidy.
To ...
0
votes
1answer
321 views
Advised auditing method for MS SQL to track changes made to a specific table by a specific user?
What is the best method for tracking changes or logging the queries done to a table by a specific user when the person is using Management Studio?
I'm using 2008 R2 Express Edition and want to ...
0
votes
2answers
138 views
Sharepoint 2007 - Transaction log full
So I have this SharePoint 2007 site that is basically trash. I'm supposed to just toss it, but I'm in need of copying all of the data in form of traditional files and folders from certain projects. ...
0
votes
1answer
148 views
MSSQL Reduce Backup/Transaction Log Size Retaining Point-In-Time Restore
Current major problem with backup sizes - I have been through many questions but am finding conflicting scenarios. I have multiple databases with the same problem but using one as an example, here are ...
2
votes
3answers
445 views
SQL Server transaction log BACKUPS are very large
In SQL Server 2008 R2 I have a database that has full backups nightly and transaction log backups every ten minutes. The database is in full recovery model.
The problem is that the backup files for ...
3
votes
1answer
139 views
Transaction log backup size change
We are running six transaction log backups every day on our SQL Server with three hours gap for each succeeding pair. I have noticed the 'data size change' column of the transaction log backups on the ...
0
votes
2answers
452 views
Transaction log full issue with SQL Server 2008 R2
I am running into 'transaction log full' issue with SQL Server 2008 R2.
My database includes 80,000 tables which contains up to 5 columns of BIGINT and there is an index for each columns.
The ...
1
vote
2answers
232 views
Transaction log: Truncate vs. backup
I have a SAP ECC instance which runs on SQL Server 2000. The database is set up with the Full recovery model, but a transaction log backup is never done (not my choice). Instead, a full backup is ...
0
votes
3answers
1k views
How can I get Transaction Logs to auto-truncate after Backup
Setup: Sql Server 2008 R2, databases set up with Full recovery mode.
I have set up a maintenance plan that backs up the transaction logs for a number of databases on the server. It is set to create ...
2
votes
2answers
138 views
SQL Server 2005 log file is getting too large
I have an initial DB which I have to import very often during development, this DB is not large but it seems like the transaction log file is getting bigger and bigger, so each time I have to delete ...
2
votes
2answers
218 views
How do I restore a SQL Server database from last night's full backup and the active transaction log file?
I have been told that it's good practise to keep your SQL Server data files and log files on physically separate disks, because it'll allow you to recover your data to the point of failure if the data ...
1
vote
4answers
298 views
Managing Log File in SQL Server 2008
These are my current settings:
Recovery mode: Simple
Logfile initial size: 10 mb
Logfile autogrowth: None
Database auto shrink: Off
The logfile autogrowth is set to None because I don't want the ...
1
vote
1answer
135 views
Setup secondary server for Transaction Log Shipping without connection to primary server
I'm having a hard time with SQL Transaction Log Shipping with the following premisses:
Server A, where data gets loaded to the database
Server B is on a remote location
The two servers never share ...
0
votes
4answers
163 views
2
votes
1answer
264 views
Does the full backup truncate transaction log?
Does the transaction log get truncated when I take a full backup using command
BACKUP DATABASE AdventureWorks
TO Adventurewks
GO
Or do I have to take a log backup separately?
BACKUP LOG ...
0
votes
1answer
179 views
Copy Transaction Log backup from Primary to non secondary server
I have a SQL Server 2005 log shipping set up, with a primary server and two secondary servers. The process goes like this:
Primary backs up to independent network drive (not on any of database ...
7
votes
1answer
165 views
Does a failed full backup invalidate future transaction log backups?
I have a server running SQL Server 2005. I have nightly full backups, with transaction log backups every 15 minutes. This is a relatively small server so I am not doing any differential backups.
If ...
0
votes
3answers
587 views
SQL Server: Log file grows more and more, and do not get merged with the MDF file
My database files look very suspicious. we are using the DB in a production stage. and I'm seeing how the LDF file grows more and more. while the MDF file seems as it is not growing at all (I don't ...
3
votes
2answers
678 views
SQL Server 2000, large transaction log, almost empty, performance issue?
For a company that I have been helping troubleshoot their database.
In SQL Server 2000, database is about 120 gig.
Something caused the transaction log to grow MUCH larger than normal to over 100 ...
1
vote
3answers
3k views
How do I backup the transaction log for a mirrored database in SQL Server?
I have a mirrored database and am trying to perform a backup of the transaction log, but after it gets to 90% it just hangs and won't go any further.
What is the correct method for backing up a DB ...
3
votes
3answers
376 views
SQL Server Log File Size Management
I have all my databases in full recovery and have the log backups happening every 15 minutes so my log files are usually pretty small. question is if there is a nightly operation that causes lots of ...
3
votes
1answer
567 views
Restore data from sql server 2008 transaction log
I have a sql server 2008 database that is in Full Recovery mode.
I haven't made a backup of the database or log.
Some data was inadvertently deleted from the database. I would like to go back to ...
2
votes
2answers
327 views
Software for browsing/searching SQL Server transaction logs
I'd like to know whether there is any piece of software that will allow the browsing/searching of SQL Server transaction logs (any version). We've previously used Lumigent Log Explorer against SQL ...
1
vote
3answers
2k views
SQL Server 2008 log file grow ultra huge even in simple recovery
We have a database in SQL Server 2008 for which the Recovery model is set to Simple.
Periodically, we run a big update on a big table (15 million rows to update). To accomplish this, we run a Stored ...
0
votes
4answers
351 views
Software to recover SQL Server 2005 ldf file
Can Anyone tell me how to recover database in SQL Server 2005 using free (i mean not shareware) software that only using ldf file?
Thanxs before
0
votes
3answers
346 views
SQL Server rolling forward lots of transactions, what should I look at?
I am running SQL Server Express on a Windows XP Embedded box. It runs for a day or two, doing some transactional processing for a POS type system, and with another system pulling data out to an OLAP ...
0
votes
2answers
538 views
Transaction Log backup fails if no full backup exists
...at least I think so.
I recently revamped my backup routine on my development server. I created a maintenance plan for user databases that did some weekly cleanup tasks, daily full backups and ...
2
votes
3answers
981 views
How do I minimize transaction log growth when copying data into SqlServer?
I've written a small app to periodically query, sanitize, and insert a legacy database's data into SqlServer. There are about 3M records and, if I make the polling widow pretty small, I can imagine ...
2
votes
5answers
8k views
How can I find the space used by a SQL Transaction Log?
The SQL Server sp_spaceused stored procedure is useful for finding out a database size, unallocated space, etc. However (as far as I can tell), it does not report that information for the transaction ...
4
votes
4answers
2k views
SQL transaction log backups conflicting with full backups?
On our SQL servers (2000, 2005, and 2008), we run full backups once a day in the evening, and transaction log backups every 2 hrs. We haven't really worried about these two processes conflicting, but ...
0
votes
5answers
3k views
SQL Server Transaction log Backup Frequency
I'm primarily a developer, but for one small in-house system I'm also currently in charge of some of the configuration of a server running SQL server enterprise edition.
The database itself sees ...
