Transaction Log Files/Virtual Log Files

I am wanting to reduce the amount of Virtual Log Files I have.  In reading through the Online Book Documentation, I realize that I have forgotten to move the Transaction Log Files to a different drive.  Now that the server is in production, I wanted to get some input about the best way of making this change.  

Can I just change the directory the log files are being written to in the DB properties without having any adverse problems occurring?
Will

http://www.strohlsitedesign.com/
http://www.WillStrohl.com/
1
hismightiness
10/1/2004 2:17:44 PM
asp.net.sql-datasource 29906 articles. 0 followers. Follow

2 Replies
956 Views

Similar Articles

[PageSpeed] 10

changing the logfile location is probably going to require to to get single user access to the db which means your going to have to boot everybody out for a few minutes
Mike Banavige
~~~~~~~~~~~~
Need a site code sample in a different language? Try converting it with: http://converter.telerik.com/
-1
mbanavige
10/2/2004 9:43:36 PM
hismightiness,

you're in for a world of hurt. you have to turn off that production database for a few minutes like what the other dood said, and re-adjust the database. There's no way to do it while processing. :(
DBCC SHRINKDATABASE
( database_name [ , target_percent ]
[ , { NOTRUNCATE | TRUNCATEONLY } ]
)
DBCC SHRINKDATABASE (UserDB, 10)
that'll give you some space if needed, but make sure you use it prior to moving things around. on a business purpose, the longer that server's down, the more trouble you'll get into. :)

Kay Lee
MySpace.com - http://www.myspace.com/kragie
Infrastructure Group
MySpace.com

- Code to live, but Live to code.
1
KraGiE
10/2/2004 10:43:07 PM
Reply:

Similar Artilces:

Cannot open transaction log file Can't use log file "JUDIC.LOG" since its shorter than expected
This is a multi-part message in MIME format. ---=_forums-1-dub4ca971d0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable Dear Sybase support Team, I tried to start a service in Sybase but all I was getting was =93Cannot open transaction log file Can't use log file "JUDIC.LOG" since its shorter than expected=94 . Tried to google out for some solutions , but all I was getting , were Sybase errors with no solutions. I kindly seek your help on what might have been the cause and the solution to the problem. Your...

How to read Transaction Log files from SQL Server using .NET
Hi all,Is anyone of you knowing about how to read .ldf (Transaction Log) files from SQL Server using .NET.e.g, suppose i m having following Database structure:database : testtable : tbltestfield : fldtestNow, i m inserting new record in blank table of fldtest using front-end application and now i want to write this event of inserted record in file or eventlog..with all necessary details contained in Transaction Log files - like  table name,time range,descriptions,field values etc.How to do that for specific to handle SQL Server events of Insert,Update,Delete? only.Awaiting for your...

No off-line transaction log file found and on-line transaction log starts at...
Hi all, ASA & ML 9.0.2.3221 Two days ago, one of our remotes stopped syncing, and unfortunately nobody noticed until today, which means that quite a lot of information got entered, and a simple re-sync would result in a considerable loss of data. The database was in E:\DBs\remote.db E:\DBs\remote.log On Tuesday, a backup of the remote for testing purposes was made through Sybase Central to a subfolder E:\DBs\test\remote.db E:\DBs\test\remote.log Ever since then, we are getting I. 10/10 05:24:48. Processing transaction logs from directory "E:\DBs\" ...

No more to delete Log file and start it with new log file
Hi we are running Adaptive Server Anywhere 6.0. But, Since April , we can not backup them, selecting the option(:Starting DB with new Log file). After back up the DB(about 3 GB), Log(about 1.9GB) and then it says "Waiting for transations to complete..", Waiting for transations to complete.."... How can we start DB with new Log file? any other solutions? Thank you for your help: ======== chungih1@paran.com You may want to send this to one of the IAnywhere newsgroups and not EAServer. -Kevin "I.H.Chung" <chungih1@paran.com> wrote in me...

how to transfer log files between servers and search these log files?
Hi Everyone, I have one Windows server.I have five Linux servers.These five Linux servers produces log files. Each log files contains informations such as domain name, first name, last name, etc. Question 1: Can I write an ASP.NET application for the Windows server so that this ASP.NET application can transfer all the specified date(from 05/22/2006 to 06/22/2006) log files from these five Linux servers to the Windowns server?  If so, how to write this ASP.NET applicationfor transfering log files? Question 2: After we transfter all the log files from these five Linux servers to the Wi...

Log files not logging
I have been given responsiblity for running our BorderManager 3.6 system. The server is no longer doing any logging. The last log file is dated August 13 2004. I just took this over. It is BM 3.6. Does anyone have any ideas where to look? Thanks Scott The administration of the log files is located in NWAdmin - select the Bordermanager Setup Tab - highlight HTTP Proxy - click on details - there is a Logging tab there that will tell you where the files are located and for how long, etc. Somtimes I have to go in and clean the logfiles out of the volume - if the volume ...

An error has occurred writing to the exception log. The permissions are not set properly on the log file or directory, or the log file has been marked as READ-ONLY.
Oups I have this message .... When I upload my portal .... What can I do ?Jerome FORTIAS on SAP Microsoft Web & Integration Consultant http://portal.go4consulting.net (powered by DNN) Make certain that the directory to which the application resides has the proper permissions (ie: Win2K = ASPNET, Win2K3 = NETWORK SERVICE). For easy of setup these objects should have full control of the directory.~ChrisNet Data Design706Horsman.us I dont know but my hosting company confirmed to me that's my host plan includes a .net supportJerome FORTIAS on SAP Microsoft Web & Integration Consul...

An error has occurred writing to the exception log. The permissions are not set properly on the log file or directory, or the log file has been marked as READ-ONLY.
I have moved my site to a new server but I am getting the following message.An error has occurred writing to the exception log. The permissions are not set properly on the log file or directory, or the log file has been marked as READ-ONLY.I have the ASP.NET user having FULL Permissions on every file/folder in the site.  But I'm noticing some files get set to Read-Only.  I reset every file to Read/Write and within a hour something is set back to read only.  ...

An error has occurred writing to the exception log. The permissions are not set properly on the log file or directory, or the log file has been marked as READ-ONLY. #2
Why I recever this error, I'm loged with Host An error has occurred writing to the exception log. The permissions are not set properly on the log file or directory, or the log file has been marked as READ-ONLY. Do you have Read/Write/Change access rights to the DotNetNuke directories? Providers\DataProviders\AccessDataProvider and Providers\DataProviders\SQLDataProvider: SQL Script logs are written hereBruce F. Gagliolo Jr.Information Technology ConsultantThe future starts today, not tomorrow. - Pope John Paul II Yes it's a local instalation, where is de log files ? Make ...

An error has occurred writing to the exception log. The permissions are not set properly on the log file or directory, or the log file has been marked as READ-ONLY. #3
Help, I rebuild sigama pro-2.0 , then it goes the error: An error has occurred writing to the exception log. The permissions are not set properly on the log file or directory, or the log file has been marked as READ-ONLY. Then I install DNN 2.1.2 clean, the error still there. Anybody, Help!...

Help! An error has occurred writing to the exception log. The permissions are not set properly on the log file or directory, or the log file has been marked as READ-ONLY.
I got this message with no more information which can help me to continue to trace. I know this is from http://localhost/DotNetNuke/components/Exceptions/XMLExceptionPublishervb.vb and Catch exc As UnauthorizedAccessException. I don't know which file is accidently set to READ ONLY due Host site and Loacl Machine download/upload transmission. Somebody can help me there? Please Willi, the file in question is in portals/_default/logs/ The message is referring to not being able to write out the exception. You will need to set the file permissions on the entire folder that DNN reside...

Transaction Log File Overlaps with Active Log
Hi! I got this error message during replication (ASA V8) ERROR MESSAGE : Transaction log file "C:\DB\040819AC.LOG" overlaps with active transaction log. Any idea on the cause? And how to solve this? Thanks very much. Geoffrey What is the exact version and build number of ASA v8 that you are using? -- Reg Domaratzki, Sybase iAnywhere Solutions Sybase Certified Professional - Sybase ASA Developer Version 8 Please reply only to the newsgroup iAnywhere Developer Community : http://www.ianywhere.com/developer iAnywhere Documentation : http://www.ianywher...

Bakcing up db, log and transaction log files
9.0.2.3274 Is there a method on WinCE devices to backup a database db file, it's transaction log and any/all temporary mobilink ntransaction log files? The important part here is the inclusion of any temp log files that mobilink maintains. TIA, Bob You can execute a BACKUP DATABASE DIRECTORY statement on Windows CE. The key is to keep any temporary files in a different directory than the database file. In the SQL Anywhere 9 docs: ASA SQL Reference SQL Statements BACKUP statement Online: http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0...

The log file is full. Back up the transaction log AGAIN!
"The log file for database 'DotNetNukedb' is full. Back up the transaction log for the database to free up some log space." This is a common message lately. There's fair activity on the site by the admin adding content but it's only one admin person and they're not working on it full time or anything so I wouldn't expect that many transactions by them. On the server a full backup is done every Sunday. T-Log backups are done every day. Sunday is the day that log truncation would occur. The database size and log size are hovering around the limit (ie we're current...

Web resources about - Transaction Log Files/Virtual Log Files - asp.net.sql-datasource

Resources last updated: 11/21/2015 6:51:32 PM