Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- SQL Server 2000 offers key enhancements
- Microsoft SQL Server 2000 has introduced new datatypes, user-defined counters, and recovery options. Discover how to put these features to work.By Tim BradleyMicrosoft SQL Server 2000 has introduced many new features, including additional datatypes, user-defined counters, and recovery options. Here's an overview of these features and a look at how...
- Tags: Performance management, Databases, Guest Contributor, datatype, Microsoft SQL Server, counter, user-defined counter, v2K, Microsoft SQL Server 2000, transaction log backup, BULK_LOGGED, performance
- Technical articles 2002-03-11
- Help! My SQL Server Log File is too big!!!
- Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim Chapman discusses the perils of not handling SQL Server log growth properly, and what can be done to correct the problems. by Tim Chapman
- Tags: Transaction Log, Transaction, Microsoft SQL Server, Backup, Server, File, Simple, Checkpoint, Transaction Log Backup, Database Mirroring Database Mirroring, Databases, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2008-09-22
Additional Resources
- SQL Transaction Log Not Truncating
- SQL 2000 SP3a, Database backup model is FULL: A full backup happens every sunday, Differential backups happens 1 time a day AM. Transaction Log happens 1 time a day PM. The Transaction log is 13GB, the transaction backup log is 15GB, everytime I run the transaction log backukp, the trans...
- Tags: backup, info@..., programming, SQL, Transaction Log
- Q&A 2005-01-19
- Restoration of SQL transaction logs
- I would like to restore SQL database and roll forward to a specific point in time by applying transaction logs.The backup software used is brightstor r11.5. I have 4 tapes (Tape 1 contains the full database),(tape 2 contains the first transaction log after the full database backup),(Tape 3 contains the...
- Tags: Backups, Databases, Programming languages, Storage, shirdisara@..., database, SQL
- Discussion threads 2007-05-02
- SQL Server Transaction Log Large & Simple Recovery Model
- I have a database that is in Simple Recovery mode and yet the Transaction log is very large - over 1 Gb and larger than the database. There is no concurrent sessions. I ran Checkpoint. Is there any danger in truncating the transaction log after a full...
- Tags: Storage, Databases, garymac12@..., database, Microsoft SQL Server
- Discussion threads 2007-05-08
- SQL Backup generates an error after backup
- I am not sure as to why this is happening, but would like if someone can point me in the right direction or help me fix this error message.It is happening with only one of my SQL database, I have setup a "Database Maintenance Plan" for the Database and it's...
- Tags: Backups, Databases, SQL backup, nishi57@..., backup, database, SQL
- Discussion threads 2007-08-09
- Restore Exchange Info Store
- I have migrated from Win Server 2000-2003. I am attempting to restore the excange information store from a backup. I am following the instruction in Microsoft's KB258243 article dismounting store and restoring same but the process fails repeatedly. Any suggestions?R Karemwhat about transaction log?how do u migrate,...
- Tags: Backups, E-mail servers, Servers, Exchange, backup
- Discussion threads 2005-11-17
- Backing up - Microsoft SQL ServerMSSQL.1Data "folder"
- I'm new to the sql environment and need to know if and when I backup the above mentioned data folder "Microsoft SQL ServerMSSQL.1data" in case of any hardware failures...do I also need to backup any of the other folders under "Microsoft SQL ServerMSSQL.1"? What about SQL Server settings associated with...
- Tags: Backups, Databases, jjstccean@..., backup, SQL, Microsoft SQL, database, Microsoft Corp.
- Discussion threads 2007-07-23
- Clear Log files Exchange2003
- My exchange log files are taking up alot of space. I ran a backup of the information store using NTbackup but i do not know how to clear the log files any help would be greatly appreciated. ThanksWhich log files?Which exchange log files are you talking about? There...
- Tags: backup, Clear, delete log files, jpknox287@..., networking
- Discussion threads 2006-09-19
- Exchange 2003 Log files not flushing
- I just deployed Exchange 2003 on Server 2003 R2. I am using the latest version of Backup Exec and have installed the agent on the box. When I do a full backup of the exchange store, the Transaction logs are not flushed. The log files are just...
- Tags: server 2003 r2, e-mail, exchange 2003, software, windows, bentgellerich@..., Exchange, Microsoft Exchange Server 2003
- Discussion threads 2006-11-10
- Sharepoint Embedded Database transaction log
- WSS 3.0 by default uses the embedded database. There are a couple of transaction logs that get built as people use Sharepoint. How can the transaction log be truncated?
- Tags: Groupware, Enterprise software, terry.engelstad@..., transaction log, Microsoft SharePoint, database
- Discussion threads 2007-08-17
- Apex SQL Log (exe)
- Apex SQL Log is a powerful SQL database auditing and recovery tool that analyzes SQL Server's own Transaction Log to display information on data changes. Since Apex SQL Log reads the Transaction Log, no database overhead is required and audits can be done on changes made even before the SQL...
- Tags: Auditing, SQL, Apex SQL Log, Programming Languages, Databases, Productivity, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Software downloads 2007-01-30
- Sybase ASE 12.5.x for UNIX: Integrating "Quiesce Database" Feature With Backup and Recovery Using a NetApp Filer Without Reboot
- This paper covers the techniques for integrating the quiesce database feature provided in ASE for backing up and restoring a Sybase ASE 12.5.x server henceforth called Sybase server for a UNIX database when a Network Appliance filer is used for database storage. This paper covers the following topics: using the...
- Tags: Recovery, NetApp Filer, Backup, Sybase Adaptive Server Enterprise, Sybase Inc., Unix, NetApp, Storage, Databases, Hardware, Enterprise Software, Software, Data Management
- White papers 2005-03-01
- MSDN Webcast: A Primer to Proper SQL Server Development (Part 02 of 10): Creating a Reliable and Automated Backup Strategy (Level 200)
- Once the database structure is in place, there is no better time to make a backup. This webcast covers creating and implementing database and log backups in Microsoft SQL Server 2005, including the testing and automating of the backup strategy. The earlier one starts planning the backup strategy, even with...
- Tags: Backup Strategy, Microsoft Developer Network, Webcast, Microsoft SQL Server, Server, Backups
- Webcasts 2005-08-12
- Tech Tip: Move transaction logs the right way in Exchange
- You might find that you need to move your transaction logs--and fast. Find out the safest, surest way to move these logs. In a perfect world, your systems perform a great backup every night, and you've sized your transaction log drive space adequately so you never run...
- Tags: Guest Contributor, E-mail Administration Tips Newsletter, Transaction Log, Backups, Productivity, E-mail Servers, Enterprise Software, Software
- Technical articles 2004-08-26
- Logfile backup&restore in sqlserver2000
- some records are deleted in a table,i want that records but i have no backupOoops, been there done that have the tee-shirt, bumper sticker and coffee mug. I would contact a sql professional to guide you through the restoration procedure. If you have a transaction log that has...
- Tags: Backups
- Q&A 2006-05-11
- Restore a spesific record from transaction log
- I want to restore a spesific record or some set of records from sql 2000 database transaction log which were deleted by misatke. What to do?
- Tags: Programming languages, Databases, veeruyadav_2020@..., transaction log
- Discussion threads 2007-09-18
- Restore your SQL Server database using transaction logs
- Most DBAs dread hearing that they need to restore a database to a point in time, especially if the database is a production database. However, knowing how to do this is of the utmost importance for a DBA's skill set. I'll walk you through the steps of how to restore...
- Tags: sql server, disaster recovery, databases
- Blog posts 2007-07-02
- Backing Up Exchange 2000 Using Windows 2000 Backup
- It is very important for any administrator to know how to backup and restore Exchange correctly. Backing up the Exchange server using the correct steps not only secures the data but also purges the transaction log files that Exchange uses. This paper explains the steps taken to backup the Exchange...
- Tags: Microsoft Windows 2000, Microsoft Windows, Microsoft Exchange 2000 Server, Exchange, E-mail Servers, Backups, Enterprise Software, Software
- White papers 2004-05-19
- Understanding the importance of transaction logs in SQL Server
- By Mark StrawmyerTransaction logs are a vital yet often overlooked component of database architecture. They are often forgotten because they are not something actively maintained like the schema contained within a database. In this article we’ll examine how transaction logs are used in Microsoft SQL Server, maintenance and potential problems...
- Tags: Crowe, Chizek and Company LLP, checkpoint, Microsoft SQL Server, database, server
- Technical articles 2004-03-17
- << Previous
- page 1 of 1
- Next >>
