How to release large unused/allocated space

Hi,

I have 6 filegroups that contain over 30 gigs of data. I manage the transaction log space efficiently by using a script and 'shrink database'. But, the allocated unused space of the data files are very large, over 30 gigs.

The configuration is standard for all files:

- Automatically grow file by percent

- Maximum file size - Unrestricted

How do I release the unused space?

Thanks,

- gshaf

Hi Gshaf,

You can issue the DBCC SHRINKDATABASE statement with TRUNCATEONLY. This will shrink the database the maximum amount possible, and release the space back to windows. If you want to control how much space in the db left for growth, you'll need to issue DBCC SHRINKFILE and specify the amount (MB) of space you want left:

DBCC SHRINKFILE(MyDataFileNameHere, 15000)

The above command will attempt to shrink the datafile "MyDataFileNameHere" to 15GB.

Cheers,

Rob

sql

How to release large unused/allocated space

Hi,

I have 6 filegroups that contain over 30 gigs of data. I manage the transaction log space efficiently by using a script and 'shrink database'. But, the allocated unused space of the data files are very large, over 30 gigs.

The configuration is standard for all files:

- Automatically grow file by percent

- Maximum file size - Unrestricted

How do I release the unused space?

Thanks,

- gshaf

Hi Gshaf,

You can issue the DBCC SHRINKDATABASE statement with TRUNCATEONLY. This will shrink the database the maximum amount possible, and release the space back to windows. If you want to control how much space in the db left for growth, you'll need to issue DBCC SHRINKFILE and specify the amount (MB) of space you want left:

DBCC SHRINKFILE(MyDataFileNameHere, 15000)

The above command will attempt to shrink the datafile "MyDataFileNameHere" to 15GB.

Cheers,

Rob

How to reduce the log file size.

Hi all,
How to reduce the physical file size of Transaction log in
SQL 7.0?>--Original Message--
>Hi all,
>How to reduce the physical file size of Transaction log
in
>SQL 7.0?
>.
>Ytan, this has happened to me. The hard drive on the SQL
box was full.|||Check out below KB articles:
INF: How to Shrink the SQL Server 7.0 Transaction Log
http://support.microsoft.com/default.aspx?scid=kb;en-us;256650
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/default.aspx?scid=kb;en-us;272318
http://www.mssqlserver.com/faq/logs-shrinklog.asp
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Ytan" <y24042003@.yahoo.com> wrote in message news:0fea01c38887$5bde8ca0$a401280a@.phx.gbl...
> Hi all,
> How to reduce the physical file size of Transaction log in
> SQL 7.0?sql

How to reduce Transaction log file ?

Our SqlServer 2000 database's transaction log is about 70 gig in size. The
Recovery model is "Full". The database and the Transaction log are backed up
everyday, but the Transaction log back up failed because there is not enough
disk space.
How can I reduce the physical file size of Transcaction Log so that I can
back it up and it does not keep growing ?
Thank you.
First, to help ensure no potential for any data loss we need to determine if
the 70gb of space being used by the tran log, is being used by data or if it
is free/white-space being held in the transaction log. There are a couple of
ways to check this, one of which involves highlighting the database in EM,
selecting the TaskPad and looking at the amount of space free/in use within
the Transaction Log device.
If a large amount of space is being consumed by data, then you should
perform a transaction log backup, truncate the log and then immediately
perform a full SQL backup to help preserve data. If you cannot perform the
transaction log backup due to the lack of available disk space, then truncate
the log (ex: backup log <dbname> with truncate_only. Immediately after
performing this step, you must perform a full SQL DB backup in order to
ensure the recoverability of your DB. You should then realize that the
remaining space in your transaction log is now free space that should be
released back to the OS. to perform this, execute a DBCC SHRINKFILE
('<TranLogLogicalName>,<minsize>) where the TranLogLogicalName is the logical
name of the tran log device for that db and the minsize is the least size
that you would like to set the tran log to (in Mbs):
ex:
DBCC SHRINKFILE ('MyDb_log',1)
You should then make sure that the database has ongoing tran log backups
that occur on a repeat frequency throughout the day and a daily/weekly
process.
Regards,
"fortunataw" wrote:

> Our SqlServer 2000 database's transaction log is about 70 gig in size. The
> Recovery model is "Full". The database and the Transaction log are backed up
> everyday, but the Transaction log back up failed because there is not enough
> disk space.
> How can I reduce the physical file size of Transcaction Log so that I can
> back it up and it does not keep growing ?
> Thank you.
>
|||Hi,
Since you do not have the enogh hard disk space; I recommend you to start
the backup cycle again after truncating the Logs.
Execute the below command to truncate the log
Backup log <dbname> with Truncate_only
After that see the size and utilization log using
DBcc SQLPERF(logspace)
Once you see the utilization is less then:-
Use dbname
go
Dbcc shrinkfile('logical_ldf_file_name',size_in_mb_to_s hrink)
go
Get the logical LDF name using the below command:-
use dbname
go
sp_helpfile
Name stands for logical name.
This will ensure that your ldf is shrinked based on the value given.
After doing the above steps do:-
1. Full database backup
2. Start your trasnaction log backup in regular intervals (every 30 minutes
minimum frequency)
The second step will ensure that you LDF will not grow abnormally.
Thanks
Hari
SQL Server MVP
"fortunataw" <fortunataw@.discussions.microsoft.com> wrote in message
news:86FAF3B0-E7F7-4F16-B719-6264666B7694@.microsoft.com...
> Our SqlServer 2000 database's transaction log is about 70 gig in size. The
> Recovery model is "Full". The database and the Transaction log are backed
> up
> everyday, but the Transaction log back up failed because there is not
> enough
> disk space.
> How can I reduce the physical file size of Transcaction Log so that I can
> back it up and it does not keep growing ?
> Thank you.
>

How to reduce Transaction log file ?

Our SqlServer 2000 database's transaction log is about 70 gig in size. The
Recovery model is "Full". The database and the Transaction log are backed up
everyday, but the Transaction log back up failed because there is not enough
disk space.
How can I reduce the physical file size of Transcaction Log so that I can
back it up and it does not keep growing ?
Thank you.First, to help ensure no potential for any data loss we need to determine if
the 70gb of space being used by the tran log, is being used by data or if it
is free/white-space being held in the transaction log. There are a couple o
f
ways to check this, one of which involves highlighting the database in EM,
selecting the TaskPad and looking at the amount of space free/in use within
the Transaction Log device.
If a large amount of space is being consumed by data, then you should
perform a transaction log backup, truncate the log and then immediately
perform a full SQL backup to help preserve data. If you cannot perform the
transaction log backup due to the lack of available disk space, then truncat
e
the log (ex: backup log <dbname> with truncate_only. Immediately after
performing this step, you must perform a full SQL DB backup in order to
ensure the recoverability of your DB. You should then realize that the
remaining space in your transaction log is now free space that should be
released back to the OS. to perform this, execute a DBCC SHRINKFILE
('<TranLogLogicalName>,<minsize> ) where the TranLogLogicalName is the logica
l
name of the tran log device for that db and the minsize is the least size
that you would like to set the tran log to (in Mbs):
ex:
DBCC SHRINKFILE ('MyDb_log',1)
You should then make sure that the database has ongoing tran log backups
that occur on a repeat frequency throughout the day and a daily/weekly
process.
Regards,
"fortunataw" wrote:

> Our SqlServer 2000 database's transaction log is about 70 gig in size. The
> Recovery model is "Full". The database and the Transaction log are backed
up
> everyday, but the Transaction log back up failed because there is not enou
gh
> disk space.
> How can I reduce the physical file size of Transcaction Log so that I can
> back it up and it does not keep growing ?
> Thank you.
>|||Hi,
Since you do not have the enogh hard disk space; I recommend you to start
the backup cycle again after truncating the Logs.
Execute the below command to truncate the log
Backup log <dbname> with Truncate_only
After that see the size and utilization log using
DBcc SQLPERF(logspace)
Once you see the utilization is less then:-
Use dbname
go
Dbcc shrinkfile('logical_ldf_file_name',size_
in_mb_to_shrink)
go
Get the logical LDF name using the below command:-
use dbname
go
sp_helpfile
Name stands for logical name.
This will ensure that your ldf is shrinked based on the value given.
After doing the above steps do:-
1. Full database backup
2. Start your trasnaction log backup in regular intervals (every 30 minutes
minimum frequency)
The second step will ensure that you LDF will not grow abnormally.
Thanks
Hari
SQL Server MVP
"fortunataw" <fortunataw@.discussions.microsoft.com> wrote in message
news:86FAF3B0-E7F7-4F16-B719-6264666B7694@.microsoft.com...
> Our SqlServer 2000 database's transaction log is about 70 gig in size. The
> Recovery model is "Full". The database and the Transaction log are backed
> up
> everyday, but the Transaction log back up failed because there is not
> enough
> disk space.
> How can I reduce the physical file size of Transcaction Log so that I can
> back it up and it does not keep growing ?
> Thank you.
>

How to reduce Transaction log file ?

Our SqlServer 2000 database's transaction log is about 70 gig in size. The
Recovery model is "Full". The database and the Transaction log are backed up
everyday, but the Transaction log back up failed because there is not enough
disk space.
How can I reduce the physical file size of Transcaction Log so that I can
back it up and it does not keep growing ?
Thank you.First, to help ensure no potential for any data loss we need to determine if
the 70gb of space being used by the tran log, is being used by data or if it
is free/white-space being held in the transaction log. There are a couple of
ways to check this, one of which involves highlighting the database in EM,
selecting the TaskPad and looking at the amount of space free/in use within
the Transaction Log device.
If a large amount of space is being consumed by data, then you should
perform a transaction log backup, truncate the log and then immediately
perform a full SQL backup to help preserve data. If you cannot perform the
transaction log backup due to the lack of available disk space, then truncate
the log (ex: backup log <dbname> with truncate_only. Immediately after
performing this step, you must perform a full SQL DB backup in order to
ensure the recoverability of your DB. You should then realize that the
remaining space in your transaction log is now free space that should be
released back to the OS. to perform this, execute a DBCC SHRINKFILE
('<TranLogLogicalName>,<minsize>) where the TranLogLogicalName is the logical
name of the tran log device for that db and the minsize is the least size
that you would like to set the tran log to (in Mbs):
ex:
DBCC SHRINKFILE ('MyDb_log',1)
You should then make sure that the database has ongoing tran log backups
that occur on a repeat frequency throughout the day and a daily/weekly
process.
Regards,
"fortunataw" wrote:
> Our SqlServer 2000 database's transaction log is about 70 gig in size. The
> Recovery model is "Full". The database and the Transaction log are backed up
> everyday, but the Transaction log back up failed because there is not enough
> disk space.
> How can I reduce the physical file size of Transcaction Log so that I can
> back it up and it does not keep growing ?
> Thank you.
>|||Hi,
Since you do not have the enogh hard disk space; I recommend you to start
the backup cycle again after truncating the Logs.
Execute the below command to truncate the log
Backup log <dbname> with Truncate_only
After that see the size and utilization log using
DBcc SQLPERF(logspace)
Once you see the utilization is less then:-
Use dbname
go
Dbcc shrinkfile('logical_ldf_file_name',size_in_mb_to_shrink)
go
Get the logical LDF name using the below command:-
use dbname
go
sp_helpfile
Name stands for logical name.
This will ensure that your ldf is shrinked based on the value given.
After doing the above steps do:-
1. Full database backup
2. Start your trasnaction log backup in regular intervals (every 30 minutes
minimum frequency)
The second step will ensure that you LDF will not grow abnormally.
Thanks
Hari
SQL Server MVP
"fortunataw" <fortunataw@.discussions.microsoft.com> wrote in message
news:86FAF3B0-E7F7-4F16-B719-6264666B7694@.microsoft.com...
> Our SqlServer 2000 database's transaction log is about 70 gig in size. The
> Recovery model is "Full". The database and the Transaction log are backed
> up
> everyday, but the Transaction log back up failed because there is not
> enough
> disk space.
> How can I reduce the physical file size of Transcaction Log so that I can
> back it up and it does not keep growing ?
> Thank you.
>

How to reduce the transaction log file

Hi all,

I know this topic has been discussed in the past, but I still don't quite get it. So please be patient with me

database size created with automatically growth of 10% with unrestricted file growth.

database size = 5 Gb used 4.5 GB (taskpad)
transaction log=8GB used 54MB (taskpad) 7.5 GB free
database run in FULL mode

full backup nightly, transaction log backup every 30 min

What should I do to free up the space that are not used in the transaction log.

Thanks for your help.DBCC SHRINKFILE
( { file_name | file_id }
{ [ , target_size ]
| [ , { EMPTYFILE | NOTRUNCATE | TRUNCATEONLY } ]
}
)|||How big is your hard drive?

If it's like 90GB...don't worry about it...

I'd be more worried though about unrestricted growth...

but you maint plan seems pretty good, and 7 gb for a tranny I would doubt would blow out...|||Doesn't your half hourly transaction log backup clear the space automatically?|||Originally posted by suresh_m_kumar
Doesn't your half hourly transaction log backup clear the space automatically?

No. that is why I don't understand|||The tranny backup every 30 min will truncate the log, but transaction log file (*ldf) is not automatically shrunk witht he truncation - see the post above with the syntax for DBCC shrink file - once you do this, the 30 min backups should keep the log to a more manageable size.|||Originally posted by joejcheng
DBCC SHRINKFILE
( { file_name | file_id }
{ [ , target_size ]
| [ , { EMPTYFILE | NOTRUNCATE | TRUNCATEONLY } ]
}
)

What option should I take : Truncateonly ??
[ , { EMPTYFILE | NOTRUNCATE | TRUNCATEONLY }|||You will want to use truncateonly I belive, so the freed space will be allocated back to the OS. Read this for an explanation of the options, or use the BOL:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_8b51.asp

How to reduce the size of transaction log

Hello,
Please could you send me the neccesary steps to reduce the size of the
transaction log in a database, without taking the database offline?
Thanks in advance.
Eduardo Sicouret
The following Microsoft KB article should help you out:
http://support.microsoft.com/kb/272318/en-us
- Peter Ward
WARDY IT solutions
"Eduardo Sicouret" wrote:

> Hello,
> Please could you send me the neccesary steps to reduce the size of the
> transaction log in a database, without taking the database offline?
> Thanks in advance.
> Eduardo Sicouret
>
>

How to reduce the size of transaction log

Hello,
Please could you send me the neccesary steps to reduce the size of the
transaction log in a database, without taking the database offline?
Thanks in advance.
Eduardo SicouretThe following Microsoft KB article should help you out:
http://support.microsoft.com/kb/272318/en-us
- Peter Ward
WARDY IT solutions
"Eduardo Sicouret" wrote:

> Hello,
> Please could you send me the neccesary steps to reduce the size of the
> transaction log in a database, without taking the database offline?
> Thanks in advance.
> Eduardo Sicouret
>
>

How to reduce the size of transaction log

Hello,
Please could you send me the neccesary steps to reduce the size of the
transaction log in a database, without taking the database offline?
Thanks in advance.
Eduardo SicouretThe following Microsoft KB article should help you out:
http://support.microsoft.com/kb/272318/en-us
- Peter Ward
WARDY IT solutions
"Eduardo Sicouret" wrote:
> Hello,
> Please could you send me the neccesary steps to reduce the size of the
> transaction log in a database, without taking the database offline?
> Thanks in advance.
> Eduardo Sicouret
>
>

how to reduce the size of transaction file

i've run "dbcc shrinkfile ('employ')"
The size of the file does not reduced.Win
It could be because the LOG file has an actve portions of transaction. Did
you run BACKUP LOG prior a SHRINKING?
select DB_ID('dbname')
Run DBCC LOGINFO(7)
If you see at the bottom transactions with status=2 that means SQL Server
'needs' them and you could not shrink.
However you can run dump inserting to moce those transaction at the
beginning of the LOG
"Win" <aaa@.aaa.com> wrote in message
news:%23Pgz2NkUGHA.328@.TK2MSFTNGP11.phx.gbl...
> i've run "dbcc shrinkfile ('employ')"
> The size of the file does not reduced.
>|||You'll find some information about why it might not shrink in
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Win" <aaa@.aaa.com> wrote in message news:%23Pgz2NkUGHA.328@.TK2MSFTNGP11.phx.gbl...arkred">
> i've run "dbcc shrinkfile ('employ')"
> The size of the file does not reduced.
>

How to reduce the log file size.

Hi all,
How to reduce the physical file size of Transaction log in
SQL 7.0?>--Original Message--
>Hi all,
>How to reduce the physical file size of Transaction log
in
>SQL 7.0?
>.
>Ytan, this has happened to me. The hard drive on the SQL
box was full.|||Check out below KB articles:
INF: How to Shrink the SQL Server 7.0 Transaction Log
http://support.microsoft.com/default.aspx?scid=kb;en-us;256650
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/default.aspx?scid=kb;en-us;272318
http://www.mssqlserver.com/faq/logs-shrinklog.asp
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Ytan" <y24042003@.yahoo.com> wrote in message news:0fea01c38887$5bde8ca0$a401280a@.phx.gbl...
> Hi all,
> How to reduce the physical file size of Transaction log in
> SQL 7.0?sql

How to recover transaction log from failed database ?.

Hi,
If data and log devices are stored on separate disks and
the disk with the data device crashes, is it then possible to backup (or
in some other was get) the transaction log from the log device so it can
be applied to the new database ?.
After the crash will database will be marked as "suspect" and it's not
possible to use the "backup log" command.
Let's say that one total backup was taken the previous night and the
last transaction log was taken 2 hours before the disk crash.
Best regards
Kjell Gunnarsson, Stockholm, Sweden.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
From BOL (Topic: How to Restore to the point of Failure)
How to restore to the point of failure (Transact-SQL)
To restore to the point of failure
1.. Execute the BACKUP LOG statement using the NO_TRUNCATE clause to back
up the currently active transaction log.
2.. Execute the RESTORE DATABASE statement using the NORECOVERY clause to
restore the database backup.
3.. Execute the RESTORE LOG statement using the NORECOVERY clause to apply
each transaction log backup.
4.. Execute the RESTORE LOG statement using the RECOVERY clause to apply
the transaction log backup created in Step 1.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Kjell Gunnarsson" <kjell.gunnarsson@.sungard.com> wrote in message
news:us4YvPcvEHA.3376@.TK2MSFTNGP12.phx.gbl...
> Hi,
> If data and log devices are stored on separate disks and
> the disk with the data device crashes, is it then possible to backup (or
> in some other was get) the transaction log from the log device so it can
> be applied to the new database ?.
> After the crash will database will be marked as "suspect" and it's not
> possible to use the "backup log" command.
> Let's say that one total backup was taken the previous night and the
> last transaction log was taken 2 hours before the disk crash.
> Best regards
> Kjell Gunnarsson, Stockholm, Sweden.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||This scenario is what the NO_TRUNCATE option for the log backup command is for.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kjell Gunnarsson" <kjell.gunnarsson@.sungard.com> wrote in message
news:us4YvPcvEHA.3376@.TK2MSFTNGP12.phx.gbl...
> Hi,
> If data and log devices are stored on separate disks and
> the disk with the data device crashes, is it then possible to backup (or
> in some other was get) the transaction log from the log device so it can
> be applied to the new database ?.
> After the crash will database will be marked as "suspect" and it's not
> possible to use the "backup log" command.
> Let's say that one total backup was taken the previous night and the
> last transaction log was taken 2 hours before the disk crash.
> Best regards
> Kjell Gunnarsson, Stockholm, Sweden.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!

How to recover transaction log from failed database ?.

Hi,
If data and log devices are stored on separate disks and
the disk with the data device crashes, is it then possible to backup (or
in some other was get) the transaction log from the log device so it can
be applied to the new database ?.
After the crash will database will be marked as "suspect" and it's not
possible to use the "backup log" command.
Let's say that one total backup was taken the previous night and the
last transaction log was taken 2 hours before the disk crash.
Best regards
Kjell Gunnarsson, Stockholm, Sweden.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!From BOL (Topic: How to Restore to the point of Failure)
How to restore to the point of failure (Transact-SQL)
To restore to the point of failure
1.. Execute the BACKUP LOG statement using the NO_TRUNCATE clause to back
up the currently active transaction log.
2.. Execute the RESTORE DATABASE statement using the NORECOVERY clause to
restore the database backup.
3.. Execute the RESTORE LOG statement using the NORECOVERY clause to apply
each transaction log backup.
4.. Execute the RESTORE LOG statement using the RECOVERY clause to apply
the transaction log backup created in Step 1.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Kjell Gunnarsson" <kjell.gunnarsson@.sungard.com> wrote in message
news:us4YvPcvEHA.3376@.TK2MSFTNGP12.phx.gbl...
> Hi,
> If data and log devices are stored on separate disks and
> the disk with the data device crashes, is it then possible to backup (or
> in some other was get) the transaction log from the log device so it can
> be applied to the new database ?.
> After the crash will database will be marked as "suspect" and it's not
> possible to use the "backup log" command.
> Let's say that one total backup was taken the previous night and the
> last transaction log was taken 2 hours before the disk crash.
> Best regards
> Kjell Gunnarsson, Stockholm, Sweden.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!|||This scenario is what the NO_TRUNCATE option for the log backup command is f
or.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kjell Gunnarsson" <kjell.gunnarsson@.sungard.com> wrote in message
news:us4YvPcvEHA.3376@.TK2MSFTNGP12.phx.gbl...
> Hi,
> If data and log devices are stored on separate disks and
> the disk with the data device crashes, is it then possible to backup (or
> in some other was get) the transaction log from the log device so it can
> be applied to the new database ?.
> After the crash will database will be marked as "suspect" and it's not
> possible to use the "backup log" command.
> Let's say that one total backup was taken the previous night and the
> last transaction log was taken 2 hours before the disk crash.
> Best regards
> Kjell Gunnarsson, Stockholm, Sweden.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!

How to recover transaction log from failed database ?.

Hi,
If data and log devices are stored on separate disks and
the disk with the data device crashes, is it then possible to backup (or
in some other was get) the transaction log from the log device so it can
be applied to the new database ?.
After the crash will database will be marked as "suspect" and it's not
possible to use the "backup log" command.
Let's say that one total backup was taken the previous night and the
last transaction log was taken 2 hours before the disk crash.
Best regards
Kjell Gunnarsson, Stockholm, Sweden.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!From BOL (Topic: How to Restore to the point of Failure)
How to restore to the point of failure (Transact-SQL)
To restore to the point of failure
1.. Execute the BACKUP LOG statement using the NO_TRUNCATE clause to back
up the currently active transaction log.
2.. Execute the RESTORE DATABASE statement using the NORECOVERY clause to
restore the database backup.
3.. Execute the RESTORE LOG statement using the NORECOVERY clause to apply
each transaction log backup.
4.. Execute the RESTORE LOG statement using the RECOVERY clause to apply
the transaction log backup created in Step 1.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Kjell Gunnarsson" <kjell.gunnarsson@.sungard.com> wrote in message
news:us4YvPcvEHA.3376@.TK2MSFTNGP12.phx.gbl...
> Hi,
> If data and log devices are stored on separate disks and
> the disk with the data device crashes, is it then possible to backup (or
> in some other was get) the transaction log from the log device so it can
> be applied to the new database ?.
> After the crash will database will be marked as "suspect" and it's not
> possible to use the "backup log" command.
> Let's say that one total backup was taken the previous night and the
> last transaction log was taken 2 hours before the disk crash.
> Best regards
> Kjell Gunnarsson, Stockholm, Sweden.
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||This scenario is what the NO_TRUNCATE option for the log backup command is for.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kjell Gunnarsson" <kjell.gunnarsson@.sungard.com> wrote in message
news:us4YvPcvEHA.3376@.TK2MSFTNGP12.phx.gbl...
> Hi,
> If data and log devices are stored on separate disks and
> the disk with the data device crashes, is it then possible to backup (or
> in some other was get) the transaction log from the log device so it can
> be applied to the new database ?.
> After the crash will database will be marked as "suspect" and it's not
> possible to use the "backup log" command.
> Let's say that one total backup was taken the previous night and the
> last transaction log was taken 2 hours before the disk crash.
> Best regards
> Kjell Gunnarsson, Stockholm, Sweden.
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

How to recover a corrupted backup file?

I backed up a database (SQL 2000) from EM but because some disk problems the
file became corrupted. Aparently part of the problem was the transaction log
did was not truncated before (it is twice the size of the data)
Is there any tool (freebie) that allows me to recover data from the
corrupted dump file? I can open it with notepad and tested it with demo
MSSQLRecovery 2.2 and there is data there. I do need to recover the db as
there is a lot of work in there.
Thank you for any input
Hi
Open a case with Microsoft Customer Support Services. They may be able to
help you.
http://support.microsoft.com
Regards
Mike
This posting is provided "AS IS" with no warranties, and confers no rights.
"Julio" <Julio@.discussions.microsoft.com> wrote in message
news:063ED50F-75B6-454E-A20D-7604F1C9415C@.microsoft.com...
>I backed up a database (SQL 2000) from EM but because some disk problems
>the
> file became corrupted. Aparently part of the problem was the transaction
> log
> did was not truncated before (it is twice the size of the data)
> Is there any tool (freebie) that allows me to recover data from the
> corrupted dump file? I can open it with notepad and tested it with demo
> MSSQLRecovery 2.2 and there is data there. I do need to recover the db as
> there is a lot of work in there.
> Thank you for any input
|||Done.
They do not recover damaged backup file. Just recover some existing
Databases with recoverable issues.
If someone has any suggestions, welcome.
Julio
"Michael Epprecht [MSFT]" wrote:

> Hi
> Open a case with Microsoft Customer Support Services. They may be able to
> help you.
> http://support.microsoft.com
> Regards
> --
> Mike
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Julio" <Julio@.discussions.microsoft.com> wrote in message
> news:063ED50F-75B6-454E-A20D-7604F1C9415C@.microsoft.com...
>
>

How to read the log of transaction of database

Hello
I tray to read the log of transactions of one databese,
but I don't know which are the process, Could you please
helpme..
Saludos desde ColombiaSQL Server transaction log architecture is SQL Server
proprietary. Only tool that im aware to read "transaction
log" is "log explorer" from Lumigent.
Visit
www.lumigent.com
- Vishal
>--Original Message--
>Hello
>I tray to read the log of transactions of one databese,
>but I don't know which are the process, Could you please
>helpme..
>
>Saludos desde Colombia
>.
>|||I know of a 3rd party tool that lets you view the SQL Transaction Log.
Lumigent Log Explorer
--
HTH
Ryan Waight, MCDBA, MCSE
"David Tinjaca" <tinjano@.hotmail.com> wrote in message
news:256801c38697$623833e0$a301280a@.phx.gbl...
> Hello
> I tray to read the log of transactions of one databese,
> but I don't know which are the process, Could you please
> helpme..
>
> Saludos desde Colombia

How to Read SQL Transaction Log ...

Good day All
I am trying to read & Understand SQL Transaction Log.
For Online Log, I use DBCC LOG...but how to understand what Row Data means.
Also How to read BackedUp (Offline) Log File?
Any help would be much appreciated.
Ramanuj Brahmachary
Database Administrator
[ MCDBA, MCSE, MCSD ]
Hi,
Try using the 3rd party tool Logexplorer from Lumigent
www.lumigent.com
Thanks
Hari
SQL Server MVP
"Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> Good day All
> I am trying to read & Understand SQL Transaction Log.
> For Online Log, I use DBCC LOG...but how to understand what Row Data
> means.
> Also How to read BackedUp (Offline) Log File?
> Any help would be much appreciated.
> --
> Ramanuj Brahmachary
> Database Administrator
> [ MCDBA, MCSE, MCSD ]
|||This is undocumented. There are third party tools that help you interpret
the log, such as Lumigent.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> Good day All
> I am trying to read & Understand SQL Transaction Log.
> For Online Log, I use DBCC LOG...but how to understand what Row Data
> means.
> Also How to read BackedUp (Offline) Log File?
> Any help would be much appreciated.
> --
> Ramanuj Brahmachary
> Database Administrator
> [ MCDBA, MCSE, MCSD ]
|||I have some 3:rd party tools listed on my links page:
http://www.karaszi.com/SQLServer/links.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> Good day All
> I am trying to read & Understand SQL Transaction Log.
> For Online Log, I use DBCC LOG...but how to understand what Row Data means.
> Also How to read BackedUp (Offline) Log File?
> Any help would be much appreciated.
> --
> Ramanuj Brahmachary
> Database Administrator
> [ MCDBA, MCSE, MCSD ]
|||There are a number of tools available
http://aspfaq.com/show.asp?id=2449
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> Good day All
> I am trying to read & Understand SQL Transaction Log.
> For Online Log, I use DBCC LOG...but how to understand what Row Data
> means.
> Also How to read BackedUp (Offline) Log File?
> Any help would be much appreciated.
> --
> Ramanuj Brahmachary
> Database Administrator
> [ MCDBA, MCSE, MCSD ]
|||Thanks very much for the overwhelming response.
My apologies, I havent mentioned that I tried some 3rd party Log Readers &
what I understand is they do very similar but are able to interprete the Row
Data field output of DBCC LOG. I was trying to find out if I can also
interprete the value in Row Data.
Any help in interpreting the field [Row Data] of DBCC LOG is much
appreciated.
Ramanuj Brahmachary
Database Administrator, Bangalore
[ MCDBA, MCSE, MCSD ]
"Jasper Smith" wrote:

> There are a number of tools available
> http://aspfaq.com/show.asp?id=2449
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
> news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
>
>
|||Also how to read BackedUp transaction LOG from file on disk.
Ramanuj Brahmachary
Database Administrator
[ MCDBA, MCSE, MCSD ]
"Ramanuj" wrote:
[vbcol=seagreen]
> Thanks very much for the overwhelming response.
> My apologies, I havent mentioned that I tried some 3rd party Log Readers &
> what I understand is they do very similar but are able to interprete the Row
> Data field output of DBCC LOG. I was trying to find out if I can also
> interprete the value in Row Data.
> Any help in interpreting the field [Row Data] of DBCC LOG is much
> appreciated.
> --
> Ramanuj Brahmachary
> Database Administrator, Bangalore
> [ MCDBA, MCSE, MCSD ]
>
> "Jasper Smith" wrote:
|||There is no documentation for interpreting the active log or a log backup. I have not seen any
scripts or anything to help with this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
news:162E993E-BBA0-4AD0-858B-672E8D6C0198@.microsoft.com...[vbcol=seagreen]
> Also how to read BackedUp transaction LOG from file on disk.
> --
> Ramanuj Brahmachary
> Database Administrator
> [ MCDBA, MCSE, MCSD ]
>
> "Ramanuj" wrote:
|||wandering how 3rd party vendors interpreting it....
Ramanuj Brahmachary
Database Administrator
[ MCDBA, MCSE, MCSD ]
"Tibor Karaszi" wrote:

> There is no documentation for interpreting the active log or a log backup. I have not seen any
> scripts or anything to help with this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
> news:162E993E-BBA0-4AD0-858B-672E8D6C0198@.microsoft.com...
>
>
|||Thanks
Ramanuj Brahmachary
Database Administrator
[ MCDBA, MCSE, MCSD ]
"Tibor Karaszi" wrote:

> I have some 3:rd party tools listed on my links page:
> http://www.karaszi.com/SQLServer/links.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
> news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
>
>

How to Read SQL Transaction Log ...

Good day All
I am trying to read & Understand SQL Transaction Log.
For Online Log, I use DBCC LOG...but how to understand what Row Data means.
Also How to read BackedUp (Offline) Log File?
Any help would be much appreciated.
--
Ramanuj Brahmachary
Database Administrator
[ MCDBA, MCSE, MCSD ]Hi,
Try using the 3rd party tool Logexplorer from Lumigent
www.lumigent.com
Thanks
Hari
SQL Server MVP
"Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> Good day All
> I am trying to read & Understand SQL Transaction Log.
> For Online Log, I use DBCC LOG...but how to understand what Row Data
> means.
> Also How to read BackedUp (Offline) Log File?
> Any help would be much appreciated.
> --
> Ramanuj Brahmachary
> Database Administrator
> [ MCDBA, MCSE, MCSD ]|||This is undocumented. There are third party tools that help you interpret
the log, such as Lumigent.
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> Good day All
> I am trying to read & Understand SQL Transaction Log.
> For Online Log, I use DBCC LOG...but how to understand what Row Data
> means.
> Also How to read BackedUp (Offline) Log File?
> Any help would be much appreciated.
> --
> Ramanuj Brahmachary
> Database Administrator
> [ MCDBA, MCSE, MCSD ]|||I have some 3:rd party tools listed on my links page:
http://www.karaszi.com/SQLServer/links.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> Good day All
> I am trying to read & Understand SQL Transaction Log.
> For Online Log, I use DBCC LOG...but how to understand what Row Data means.
> Also How to read BackedUp (Offline) Log File?
> Any help would be much appreciated.
> --
> Ramanuj Brahmachary
> Database Administrator
> [ MCDBA, MCSE, MCSD ]|||There are a number of tools available
http://aspfaq.com/show.asp?id=2449
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> Good day All
> I am trying to read & Understand SQL Transaction Log.
> For Online Log, I use DBCC LOG...but how to understand what Row Data
> means.
> Also How to read BackedUp (Offline) Log File?
> Any help would be much appreciated.
> --
> Ramanuj Brahmachary
> Database Administrator
> [ MCDBA, MCSE, MCSD ]|||Thanks very much for the overwhelming response.
My apologies, I havent mentioned that I tried some 3rd party Log Readers &
what I understand is they do very similar but are able to interprete the Row
Data field output of DBCC LOG. I was trying to find out if I can also
interprete the value in Row Data.
Any help in interpreting the field [Row Data] of DBCC LOG is much
appreciated.
--
Ramanuj Brahmachary
Database Administrator, Bangalore
[ MCDBA, MCSE, MCSD ]
"Jasper Smith" wrote:
> There are a number of tools available
> http://aspfaq.com/show.asp?id=2449
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
> news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> > Good day All
> > I am trying to read & Understand SQL Transaction Log.
> > For Online Log, I use DBCC LOG...but how to understand what Row Data
> > means.
> > Also How to read BackedUp (Offline) Log File?
> >
> > Any help would be much appreciated.
> > --
> > Ramanuj Brahmachary
> > Database Administrator
> > [ MCDBA, MCSE, MCSD ]
>
>|||Also how to read BackedUp transaction LOG from file on disk.
--
Ramanuj Brahmachary
Database Administrator
[ MCDBA, MCSE, MCSD ]
"Ramanuj" wrote:
> Thanks very much for the overwhelming response.
> My apologies, I havent mentioned that I tried some 3rd party Log Readers &
> what I understand is they do very similar but are able to interprete the Row
> Data field output of DBCC LOG. I was trying to find out if I can also
> interprete the value in Row Data.
> Any help in interpreting the field [Row Data] of DBCC LOG is much
> appreciated.
> --
> Ramanuj Brahmachary
> Database Administrator, Bangalore
> [ MCDBA, MCSE, MCSD ]
>
> "Jasper Smith" wrote:
> > There are a number of tools available
> > http://aspfaq.com/show.asp?id=2449
> >
> > --
> > HTH
> >
> > Jasper Smith (SQL Server MVP)
> > http://www.sqldbatips.com
> > I support PASS - the definitive, global
> > community for SQL Server professionals -
> > http://www.sqlpass.org
> >
> > "Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
> > news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> > > Good day All
> > > I am trying to read & Understand SQL Transaction Log.
> > > For Online Log, I use DBCC LOG...but how to understand what Row Data
> > > means.
> > > Also How to read BackedUp (Offline) Log File?
> > >
> > > Any help would be much appreciated.
> > > --
> > > Ramanuj Brahmachary
> > > Database Administrator
> > > [ MCDBA, MCSE, MCSD ]
> >
> >
> >|||There is no documentation for interpreting the active log or a log backup. I have not seen any
scripts or anything to help with this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
news:162E993E-BBA0-4AD0-858B-672E8D6C0198@.microsoft.com...
> Also how to read BackedUp transaction LOG from file on disk.
> --
> Ramanuj Brahmachary
> Database Administrator
> [ MCDBA, MCSE, MCSD ]
>
> "Ramanuj" wrote:
>> Thanks very much for the overwhelming response.
>> My apologies, I havent mentioned that I tried some 3rd party Log Readers &
>> what I understand is they do very similar but are able to interprete the Row
>> Data field output of DBCC LOG. I was trying to find out if I can also
>> interprete the value in Row Data.
>> Any help in interpreting the field [Row Data] of DBCC LOG is much
>> appreciated.
>> --
>> Ramanuj Brahmachary
>> Database Administrator, Bangalore
>> [ MCDBA, MCSE, MCSD ]
>>
>> "Jasper Smith" wrote:
>> > There are a number of tools available
>> > http://aspfaq.com/show.asp?id=2449
>> >
>> > --
>> > HTH
>> >
>> > Jasper Smith (SQL Server MVP)
>> > http://www.sqldbatips.com
>> > I support PASS - the definitive, global
>> > community for SQL Server professionals -
>> > http://www.sqlpass.org
>> >
>> > "Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
>> > news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
>> > > Good day All
>> > > I am trying to read & Understand SQL Transaction Log.
>> > > For Online Log, I use DBCC LOG...but how to understand what Row Data
>> > > means.
>> > > Also How to read BackedUp (Offline) Log File?
>> > >
>> > > Any help would be much appreciated.
>> > > --
>> > > Ramanuj Brahmachary
>> > > Database Administrator
>> > > [ MCDBA, MCSE, MCSD ]
>> >
>> >
>> >|||wandering how 3rd party vendors interpreting it....
--
Ramanuj Brahmachary
Database Administrator
[ MCDBA, MCSE, MCSD ]
"Tibor Karaszi" wrote:
> There is no documentation for interpreting the active log or a log backup. I have not seen any
> scripts or anything to help with this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
> news:162E993E-BBA0-4AD0-858B-672E8D6C0198@.microsoft.com...
> > Also how to read BackedUp transaction LOG from file on disk.
> > --
> > Ramanuj Brahmachary
> > Database Administrator
> > [ MCDBA, MCSE, MCSD ]
> >
> >
> > "Ramanuj" wrote:
> >
> >> Thanks very much for the overwhelming response.
> >>
> >> My apologies, I havent mentioned that I tried some 3rd party Log Readers &
> >> what I understand is they do very similar but are able to interprete the Row
> >> Data field output of DBCC LOG. I was trying to find out if I can also
> >> interprete the value in Row Data.
> >> Any help in interpreting the field [Row Data] of DBCC LOG is much
> >> appreciated.
> >> --
> >> Ramanuj Brahmachary
> >> Database Administrator, Bangalore
> >> [ MCDBA, MCSE, MCSD ]
> >>
> >>
> >> "Jasper Smith" wrote:
> >>
> >> > There are a number of tools available
> >> > http://aspfaq.com/show.asp?id=2449
> >> >
> >> > --
> >> > HTH
> >> >
> >> > Jasper Smith (SQL Server MVP)
> >> > http://www.sqldbatips.com
> >> > I support PASS - the definitive, global
> >> > community for SQL Server professionals -
> >> > http://www.sqlpass.org
> >> >
> >> > "Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
> >> > news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> >> > > Good day All
> >> > > I am trying to read & Understand SQL Transaction Log.
> >> > > For Online Log, I use DBCC LOG...but how to understand what Row Data
> >> > > means.
> >> > > Also How to read BackedUp (Offline) Log File?
> >> > >
> >> > > Any help would be much appreciated.
> >> > > --
> >> > > Ramanuj Brahmachary
> >> > > Database Administrator
> >> > > [ MCDBA, MCSE, MCSD ]
> >> >
> >> >
> >> >
>
>|||Thanks
--
Ramanuj Brahmachary
Database Administrator
[ MCDBA, MCSE, MCSD ]
"Tibor Karaszi" wrote:
> I have some 3:rd party tools listed on my links page:
> http://www.karaszi.com/SQLServer/links.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
> news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> > Good day All
> > I am trying to read & Understand SQL Transaction Log.
> > For Online Log, I use DBCC LOG...but how to understand what Row Data means.
> > Also How to read BackedUp (Offline) Log File?
> >
> > Any help would be much appreciated.
> > --
> > Ramanuj Brahmachary
> > Database Administrator
> > [ MCDBA, MCSE, MCSD ]
>
>|||Thanks
--
Ramanuj Brahmachary
Database Administrator
[ MCDBA, MCSE, MCSD ]
"Hari Prasad" wrote:
> Hi,
> Try using the 3rd party tool Logexplorer from Lumigent
> www.lumigent.com
> Thanks
> Hari
> SQL Server MVP
> "Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
> news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> > Good day All
> > I am trying to read & Understand SQL Transaction Log.
> > For Online Log, I use DBCC LOG...but how to understand what Row Data
> > means.
> > Also How to read BackedUp (Offline) Log File?
> >
> > Any help would be much appreciated.
> > --
> > Ramanuj Brahmachary
> > Database Administrator
> > [ MCDBA, MCSE, MCSD ]
>
>

How to Read SQL Transaction Log ...

Good day All
I am trying to read & Understand SQL Transaction Log.
For Online Log, I use DBCC LOG...but how to understand what Row Data means.
Also How to read BackedUp (Offline) Log File?
Any help would be much appreciated.
--
Ramanuj Brahmachary
Database Administrator
[ MCDBA, MCSE, MCSD ]Hi,
Try using the 3rd party tool Logexplorer from Lumigent
www.lumigent.com
Thanks
Hari
SQL Server MVP
"Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> Good day All
> I am trying to read & Understand SQL Transaction Log.
> For Online Log, I use DBCC LOG...but how to understand what Row Data
> means.
> Also How to read BackedUp (Offline) Log File?
> Any help would be much appreciated.
> --
> Ramanuj Brahmachary
> Database Administrator
> [ MCDBA, MCSE, MCSD ]|||This is undocumented. There are third party tools that help you interpret
the log, such as Lumigent.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> Good day All
> I am trying to read & Understand SQL Transaction Log.
> For Online Log, I use DBCC LOG...but how to understand what Row Data
> means.
> Also How to read BackedUp (Offline) Log File?
> Any help would be much appreciated.
> --
> Ramanuj Brahmachary
> Database Administrator
> [ MCDBA, MCSE, MCSD ]|||I have some 3:rd party tools listed on my links page:
http://www.karaszi.com/SQLServer/links.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> Good day All
> I am trying to read & Understand SQL Transaction Log.
> For Online Log, I use DBCC LOG...but how to understand what Row Data mean
s.
> Also How to read BackedUp (Offline) Log File?
> Any help would be much appreciated.
> --
> Ramanuj Brahmachary
> Database Administrator
> [ MCDBA, MCSE, MCSD ]|||There are a number of tools available
http://aspfaq.com/show.asp?id=2449
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
> Good day All
> I am trying to read & Understand SQL Transaction Log.
> For Online Log, I use DBCC LOG...but how to understand what Row Data
> means.
> Also How to read BackedUp (Offline) Log File?
> Any help would be much appreciated.
> --
> Ramanuj Brahmachary
> Database Administrator
> [ MCDBA, MCSE, MCSD ]|||Thanks very much for the overwhelming response.
My apologies, I havent mentioned that I tried some 3rd party Log Readers &
what I understand is they do very similar but are able to interprete the Row
Data field output of DBCC LOG. I was trying to find out if I can also
interprete the value in Row Data.
Any help in interpreting the field [Row Data] of DBCC LOG is much
appreciated.
--
Ramanuj Brahmachary
Database Administrator, Bangalore
[ MCDBA, MCSE, MCSD ]
"Jasper Smith" wrote:

> There are a number of tools available
> http://aspfaq.com/show.asp?id=2449
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
> news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
>
>|||Also how to read BackedUp transaction LOG from file on disk.
--
Ramanuj Brahmachary
Database Administrator
[ MCDBA, MCSE, MCSD ]
"Ramanuj" wrote:
[vbcol=seagreen]
> Thanks very much for the overwhelming response.
> My apologies, I havent mentioned that I tried some 3rd party Log Readers &
> what I understand is they do very similar but are able to interprete the R
ow
> Data field output of DBCC LOG. I was trying to find out if I can also
> interprete the value in Row Data.
> Any help in interpreting the field [Row Data] of DBCC LOG is much
> appreciated.
> --
> Ramanuj Brahmachary
> Database Administrator, Bangalore
> [ MCDBA, MCSE, MCSD ]
>
> "Jasper Smith" wrote:
>|||There is no documentation for interpreting the active log or a log backup. I
have not seen any
scripts or anything to help with this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
news:162E993E-BBA0-4AD0-858B-672E8D6C0198@.microsoft.com...[vbcol=seagreen]
> Also how to read BackedUp transaction LOG from file on disk.
> --
> Ramanuj Brahmachary
> Database Administrator
> [ MCDBA, MCSE, MCSD ]
>
> "Ramanuj" wrote:
>|||wandering how 3rd party vendors interpreting it....
--
Ramanuj Brahmachary
Database Administrator
[ MCDBA, MCSE, MCSD ]
"Tibor Karaszi" wrote:

> There is no documentation for interpreting the active log or a log backup.
I have not seen any
> scripts or anything to help with this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
> news:162E993E-BBA0-4AD0-858B-672E8D6C0198@.microsoft.com...
>
>|||Thanks
--
Ramanuj Brahmachary
Database Administrator
[ MCDBA, MCSE, MCSD ]
"Tibor Karaszi" wrote:

> I have some 3:rd party tools listed on my links page:
> http://www.karaszi.com/SQLServer/links.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Ramanuj" <Ramanuj@.discussions.microsoft.com> wrote in message
> news:68B9091E-649C-45C9-8B5B-4F9606FCC876@.microsoft.com...
>
>