by: BashiraInTrouble |
last post by:
Hi Friends,
I have tried almost everything but I cant seem to shrink the
transaction log.
Executing DBCC SQLPERF(LOGSPACE)
gives me this info:
Database Log Size (MB) Log Space Used (%) ...
|
by: hank |
last post by:
Hi All
In the Circular Logging when the Primary Log file fill up, the
database manager will creat a secondary log files for the transaction;
when this transaction finished, the secondary log...
|
by: hype |
last post by:
Hi,
How can I find out how much space has been used in the log file
and how much of it is free or yet to be used ?
Thanks,
Hype
|
by: Lew |
last post by:
Hi,
I am a bit confused about what I'm seeing on my systems. I am
trying to develop a script that will determine what percentage of the
total log space is being used. If it is too high (80%)...
|
by: nek |
last post by:
Greetings,
I tried to implement log shipping using PULL method as described in
'The Basics of DB2 Log Shipping' by Dale McInnis, but found the
subsequent "rollforward" did not go beyond the...
|
by: Sean Shanny |
last post by:
To all,
I restarted postgres this morning to make a configuration file change
take effect and when I looked at the serverlog to make sure things were
ok I found the prior shutdown message(*in...
|
by: Hubert Fröhlich |
last post by:
Hi list,
when doing a large Insert I get in the logfile:
2004-08-03 07:23:46 LOG: recycled transaction log file "000001BA000000BD"
2004-08-03 07:34:00 LOG: recycled transaction log file...
|
by: Jmc |
last post by:
Hi
I'm trying to build a log viewer, its going to be part of a
contentmanagement system and needs some extra features that commersial
logviewers don´t have.
The log files (IIS log) are...
|
by: Eugene F |
last post by:
The database is currently in the circular logging mode (no log
archiving). I want to track the database transaction log switch history
in form of (switch-timestamp, active-log-sequence-number) to...
|
by: aj |
last post by:
SQL Server SP2 9.0.3042 64-bit
I recently put my first SQL Server DB in production. In the "other"
database that I use (not interested in any arguments), you can indicate
the desired size of...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|