How to trancate transaction log?

I use the backup wizard to run a transaction log backup with option to remov
e
inactive transaction logs. After completing the backup, the size of
transaction log file does not shrink. Why? Thanks.Are you using the full or bulk-logged recovery mode? I guess you are if the
backup completes successfully. You probably have an uncommitted transaction
that's preventing the log being truncated. Look at the output from DBCC
OPENTRAN to determine the age of the oldest uncommitted transaction (on SQL
2000)
Regards
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"joeau" <joeau@.discussions.microsoft.com> wrote in message
news:01EAAADA-8F83-4CF4-A0A3-AE776092F7EB@.microsoft.com...
> I use the backup wizard to run a transaction log backup with option to
remove
> inactive transaction logs. After completing the backup, the size of
> transaction log file does not shrink. Why? Thanks.|||Hi
The physical size of the log file will not change when you do a backup -
that will only truncate the log. To reduce the filesize, you'll have to
shrink the file.
You can try to look up DBCC SHRINKFILE in BOL - and also check out
http://www.karaszi.com/sqlserver/info_dont_shrink.asp
Regards
Steen
joeau wrote:
> I use the backup wizard to run a transaction log backup with option
> to remove inactive transaction logs. After completing the backup, the
> size of transaction log file does not shrink. Why? Thanks.|||Removing unused transactions means incorporating those committed
transactions in the full backup as well.
Truncation does not imply file shrinkage, just the removal, actually just a
mark on the virtual logs, that those transactions have completed and backed
up.
Although the transaction log file may not have been shrunk like you'd like,
because all of the old transactions have committed and backed up, the
transaction log does not have any reason to grow either because it can now
use those freed up virtaul logs.
Sincerely,
Anthony Thomas
"joeau" <joeau@.discussions.microsoft.com> wrote in message
news:01EAAADA-8F83-4CF4-A0A3-AE776092F7EB@.microsoft.com...
I use the backup wizard to run a transaction log backup with option to
remove
inactive transaction logs. After completing the backup, the size of
transaction log file does not shrink. Why? Thanks.

How to trancate transaction log?

I use the backup wizard to run a transaction log backup with option to remove
inactive transaction logs. After completing the backup, the size of
transaction log file does not shrink. Why? Thanks.
Are you using the full or bulk-logged recovery mode? I guess you are if the
backup completes successfully. You probably have an uncommitted transaction
that's preventing the log being truncated. Look at the output from DBCC
OPENTRAN to determine the age of the oldest uncommitted transaction (on SQL
2000)
Regards
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"joeau" <joeau@.discussions.microsoft.com> wrote in message
news:01EAAADA-8F83-4CF4-A0A3-AE776092F7EB@.microsoft.com...
> I use the backup wizard to run a transaction log backup with option to
remove
> inactive transaction logs. After completing the backup, the size of
> transaction log file does not shrink. Why? Thanks.
|||Hi
The physical size of the log file will not change when you do a backup -
that will only truncate the log. To reduce the filesize, you'll have to
shrink the file.
You can try to look up DBCC SHRINKFILE in BOL - and also check out
http://www.karaszi.com/sqlserver/info_dont_shrink.asp
Regards
Steen
joeau wrote:
> I use the backup wizard to run a transaction log backup with option
> to remove inactive transaction logs. After completing the backup, the
> size of transaction log file does not shrink. Why? Thanks.
|||Removing unused transactions means incorporating those committed
transactions in the full backup as well.
Truncation does not imply file shrinkage, just the removal, actually just a
mark on the virtual logs, that those transactions have completed and backed
up.
Although the transaction log file may not have been shrunk like you'd like,
because all of the old transactions have committed and backed up, the
transaction log does not have any reason to grow either because it can now
use those freed up virtaul logs.
Sincerely,
Anthony Thomas
"joeau" <joeau@.discussions.microsoft.com> wrote in message
news:01EAAADA-8F83-4CF4-A0A3-AE776092F7EB@.microsoft.com...
I use the backup wizard to run a transaction log backup with option to
remove
inactive transaction logs. After completing the backup, the size of
transaction log file does not shrink. Why? Thanks.
sql

How to trancate transaction log?

I use the backup wizard to run a transaction log backup with option to remove
inactive transaction logs. After completing the backup, the size of
transaction log file does not shrink. Why? Thanks.Are you using the full or bulk-logged recovery mode? I guess you are if the
backup completes successfully. You probably have an uncommitted transaction
that's preventing the log being truncated. Look at the output from DBCC
OPENTRAN to determine the age of the oldest uncommitted transaction (on SQL
2000)
Regards
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"joeau" <joeau@.discussions.microsoft.com> wrote in message
news:01EAAADA-8F83-4CF4-A0A3-AE776092F7EB@.microsoft.com...
> I use the backup wizard to run a transaction log backup with option to
remove
> inactive transaction logs. After completing the backup, the size of
> transaction log file does not shrink. Why? Thanks.|||Hi
The physical size of the log file will not change when you do a backup -
that will only truncate the log. To reduce the filesize, you'll have to
shrink the file.
You can try to look up DBCC SHRINKFILE in BOL - and also check out
http://www.karaszi.com/sqlserver/info_dont_shrink.asp
Regards
Steen
joeau wrote:
> I use the backup wizard to run a transaction log backup with option
> to remove inactive transaction logs. After completing the backup, the
> size of transaction log file does not shrink. Why? Thanks.|||Removing unused transactions means incorporating those committed
transactions in the full backup as well.
Truncation does not imply file shrinkage, just the removal, actually just a
mark on the virtual logs, that those transactions have completed and backed
up.
Although the transaction log file may not have been shrunk like you'd like,
because all of the old transactions have committed and backed up, the
transaction log does not have any reason to grow either because it can now
use those freed up virtaul logs.
Sincerely,
Anthony Thomas
--
"joeau" <joeau@.discussions.microsoft.com> wrote in message
news:01EAAADA-8F83-4CF4-A0A3-AE776092F7EB@.microsoft.com...
I use the backup wizard to run a transaction log backup with option to
remove
inactive transaction logs. After completing the backup, the size of
transaction log file does not shrink. Why? Thanks.

How to tell sql server the maximum size my temp table will grow so that it does at most 1

How to tell sql server the maximum size my temp table will grow so that it
does at most 1 memory allocation?
DR (softwareengineer98037@.yahoo.com) writes:
> How to tell sql server the maximum size my temp table will grow so that it
> does at most 1 memory allocation?
You have posted this question independently to a whole bunch of newsgroups,
and it's not on topic to all. Only post to groups where the question is
relevant, and if you need to target multiple groups, cross-post, don't
multi-post. There is an answer for you in .programming.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
sql

How to tell sql server the maximum size my temptable will grow so that it does at most 1 m

How to tell sql server the maximum size my temptable will grow so that it
does at most 1 memory allocation?
You can't. I wouldn't worry too much about it as there are generally many
more things you can be tuning to get peak performance than this.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"DR" <softwareengineer98037@.yahoo.com> wrote in message
news:u$S2%23cILIHA.6108@.TK2MSFTNGP03.phx.gbl...
> How to tell sql server the maximum size my temptable will grow so that it
> does at most 1 memory allocation?
>
sql

How to tell sql server the maximum size my temptable will grow so that it does at most 1 m

How to tell sql server the maximum size my temptable will grow so that it
does at most 1 memory allocation?
Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"DR" <softwareengineer98037@.yahoo.com> wrote in message
news:O7YWSdILIHA.3400@.TK2MSFTNGP03.phx.gbl...
> How to tell sql server the maximum size my temptable will grow so that it
> does at most 1 memory allocation?
>

How to tell sql server the maximum size my temptable will grow so that it does at most 1 m

How to tell sql server the maximum size my temptable will grow so that it
does at most 1 memory allocation?
Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"DR" <softwareengineer98037@.yahoo.com> wrote in message
news:%23ddnbdILIHA.3400@.TK2MSFTNGP03.phx.gbl...
> How to tell sql server the maximum size my temptable will grow so that it
> does at most 1 memory allocation?
>

How to tell sql server the maximum size my temp table will grow so that it does at most 1

How to tell sql server the maximum size my temp table will grow so that it
does at most 1 memory allocation?
Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"DR" <softwareengineer98037@.yahoo.com> wrote in message
news:eTPVXgILIHA.3992@.TK2MSFTNGP03.phx.gbl...
> How to tell sql server the maximum size my temp table will grow so that it
> does at most 1 memory allocation?
>

How to tell sql server the maximum size my temp table will grow so that it does at most 1

How to tell sql server the maximum size my temp table will grow so that it
does at most 1 memory allocation?
Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"DR" <softwareengineer98037@.yahoo.com> wrote in message
news:uwKEOgILIHA.3992@.TK2MSFTNGP03.phx.gbl...
> How to tell sql server the maximum size my temp table will grow so that it
> does at most 1 memory allocation?
>

How to Store Font and Size Information

Hi,

I am trying to store RichTexBox information, such as the formating of the paragraph, color, font and etc. Is that possible to store this kind of information in Sql Server 2005 Compact Edition without stripping down the properties one by one?

I am trying to store a sentence which contain of multiple color or font for different words. Is there anyway to store those information?

thanks.
You can store the entire RTF contents of the control to a ntext field in SQL CE.|||

ErikEJ wrote:

You can store the entire RTF contents of the control to a ntext field in SQL CE.

But what "container" should we use in C# ? a stream?

thx!

|||

SQL CE’s ntext maps to "string" in C#. That's what RTF is - a string with special markup.

You can, however, use Image type in the database and a byte array in C# which you can access via MemoryStream if string is not good enough.

|||

Ilya Tumanov wrote:

SQL CE’s ntext maps to "string" in C#. That's what RTF is - a string with special markup.

You can, however, use Image type in the database and a byte array in C# which you can access via MemoryStream if string is not good enough.

thanks

How to Store Font and Size Information

Hi,

I am trying to store RichTexBox information, such as the formating of the paragraph, color, font and etc. Is that possible to store this kind of information in Sql Server 2005 Compact Edition without stripping down the properties one by one?

I am trying to store a sentence which contain of multiple color or font for different words. Is there anyway to store those information?

thanks.
You can store the entire RTF contents of the control to a ntext field in SQL CE.|||

ErikEJ wrote:

You can store the entire RTF contents of the control to a ntext field in SQL CE.

But what "container" should we use in C# ? a stream?

thx!

|||

SQL CE’s ntext maps to "string" in C#. That's what RTF is - a string with special markup.

You can, however, use Image type in the database and a byte array in C# which you can access via MemoryStream if string is not good enough.

|||

Ilya Tumanov wrote:

SQL CE’s ntext maps to "string" in C#. That's what RTF is - a string with special markup.

You can, however, use Image type in the database and a byte array in C# which you can access via MemoryStream if string is not good enough.

thanks