Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- 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
- 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
- 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
- Exchange 2003 disk space requirements per drive
- I have a GroupWise environment and have been asked put on a project to migrate to Exchange 2003. I cannot seem to find any information on disk space requirements for the database and transaction log sizing for any size environment. I have 2500 users and we average 30 inbound...
- Tags: E-mail servers, Storage, jhussey@..., disk, Microsoft Exchange Server 2003
- Discussion threads 2007-04-23
- Running totals in SQL Server queries
- Impractical in reality with large tableThe query has to calculate the sum for every return row.Other Options?What would be some other options to do this? Or are you simply saying that this should not be done when there is a large recordset?
- Tags: programming, feedback, getDate, tequilla@..., Microsoft SQL Server
- Discussion threads 2006-11-07
- 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
- A primer on SQL Server database files
- Proper placement of your SQL Server database files is vital to good database performance. In this article, Tim Chapman discusses some of the details that can lead you on the right path towards SQL Server database file bliss. A high-performance database system is the product of good database...
- Tags: Microsoft SQL Server, Tim Chapman, Databases, Storage, RAID, database, transaction log, SQL Server Newsletter, Data, Database Engine, File, High-performance Database System, Enterprise Software, Software, Data Management, Hardware
- Technical articles 2006-07-24
- Optimizing hard drive configurations for Exchange Server
- As you probably know, Exchange Server is an extremelyresource hungry application. The one resource that Exchange is probably themost dependent on is the server's hard disk. It's easy to think of hard diskresources in terms of capacity, but when it comes to Exchange Server it isequally important to consider the...
- Tags: Brien M. Posey MCSE, database, disk, Exchange, hard drive, Microsoft Exchange Server, server
- Technical articles 2006-03-21
- dbcc logical scan
- I have a database on sql server 2000 sp4. Not long ago I had something wrong with my transaction log and the DB went into "suspect mode". Microsoft showed me basically how to destroy the transaction log and rebuild it. I didnt loose any data, everything had already been commited....
- Tags: Databases, fragmentation, Avg
- Discussion threads 2005-12-29
- 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
- Disk Partitioning for Database Servers on W2003
- Hi allJust wanted to get some opinions on disk partitioning for a DB server Im implementingI have a HP Server with 6 drives and an array card. Im going to setup one array as a mirror for two disks for the OS/Transaction log and another array as a RAID5 set...
- Tags: damon.lane@..., database, database server, disk, disk arrays, hardware, I/O, Microsoft SQL Server, RAID5, sql server
- Discussion threads 2005-06-17
- 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
- Decision Support: Configuration design prep in Exchange 2000 planning
- Be nice to update this article for Exch 2003I've been looking for a while and I haven't seen an article or section in a book that lists the reasons to create additional stores and storage groups. This is good information and I would like to see the list expanded. People...
- Tags: backup, database, decision support, Exchange, Microsoft Exchange 2000 Server, networking, techrepublic@...
- Discussion threads 2004-11-21
- Understanding the importance of transaction logs in SQL Server
- Actual usageI was accidentally issue this command DELETE * FROM table in sql query analyzer. Can I recover the data using transaction logs?
- Tags: it management, Microsoft SQL Server, rcipapo@..., server, Understanding
- Discussion threads 2004-11-12
- Moving Exchange 2000 files
- I am running SBS 2000. Currently my exchange database is 7.5 GB and resides on a 9 GB logical drive. I have a spare 18 GB drive in the same machine. Can I just copy the Exchange programs and files to the new drive and use disk...
- Tags: jspaz@..., Microsoft Exchange 2000 Server, windows
- Q&A 2004-10-22
- 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
- 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
- TechRepublic Tutorial: Rearrange Exchange 2000 databases to improve performance
- Optimize performance and avoid bottlenecks by paying close attention to the way you arrange Exchange 2000s important files.In an Exchange 2000 Server environment, how well your server performs depends largely on how well it's configured. The way you use your hard drives is one of the most important configuration issues....
- Tags: Storage, Databases, E-mail servers, performance, Brien M. Posey MCSE, database, transaction log, Microsoft Exchange 2000 Server
- Technical articles 2001-10-29
- Build Your Skills: Managing Exchange 2000 transaction logs and database files
- Manually move store files and transaction logs to a different volume with the Exchange System Manager.If you have experience administering Exchange Server 5.x, you’re no doubt familiar with the Exchange Optimizer, which analyzes the server and helps you restructure it. For example, you can use the Exchange Optimizer to move...
- Tags: Backups, E-mail servers, Jim Boyce, database, Microsoft Corp., transaction log
- Technical articles 2001-03-13
- << Previous
- page 1 of 1
- Next >>
