good time to shrink TLog?

sql2k sp3
Ive got a db that I just created 3 days ago and already
the TLog is 5 gigs. I do a Full Backup at 2AM every day
and TLog backups every 5 minutes between 5:AM and 7:PM.
This is a replicated db. Every night before the Full
Backup we turn off replication, truncate 3 tables, bulk
insert new data into those tables, turn on replication.
(Of course that explains the big TLog.) The only way I can
get the size of the TLog down by a signifigant amount is
to do a "backup log with truncate_only" followed by
shrinking the file. Does anyone know, based on this
scenario, when a good time to do this stuff is? I tried
only doing the shrink part but it didnt reduce the size a
whole lot. Is there another way to go about this?
Thanks.Chris
I'm finding some of the things you are doing a little hard
to understand, but that may be due to not having all the
info. What are you using replication for? It seems strange
to turn it off, do some major changes to your database and
then turn it back on. Do you not replicate those changes?
Are you doing a database snapshot following the work? How
are you keeping you databases in line with this process?
One possible solution for your actual problem, depending
on disk space and DR strategy, would be to take a full
backup before the changes, go to simple recovery mode.
Perform the changes. Switch back to full recovery after
the changes and take another full backup. This should cut
down on the growth to your transaction log.
I think a better understanding of your replication usage
may lead to a better solution.
Regards
John|||What are you using replication for? It seems strange
>to turn it off, do some major changes to your database
and
>then turn it back on.
So our client can access this data. I need to turn off
replication because I need to truncate these table @. night.
Do you not replicate those changes?
>Are you doing a database snapshot following the work?
Yes. These tables are in their own Publication and it gets
re-snapshotted every night.
How
>are you keeping you databases in line with this process?
Not sure I get this one?
So do you know of a good time I could truncate and shrink
the log?
>--Original Message--
>Chris
>I'm finding some of the things you are doing a little
hard
>to understand, but that may be due to not having all the
>info. What are you using replication for? It seems
strange
>to turn it off, do some major changes to your database
and
>then turn it back on. Do you not replicate those changes?
>Are you doing a database snapshot following the work? How
>are you keeping you databases in line with this process?
>One possible solution for your actual problem, depending
>on disk space and DR strategy, would be to take a full
>backup before the changes, go to simple recovery mode.
>Perform the changes. Switch back to full recovery after
>the changes and take another full backup. This should cut
>down on the growth to your transaction log.
>I think a better understanding of your replication usage
>may lead to a better solution.
>Regards
>John
>.
>|||Chris
Is my suggestion to change the recovery mode during the
busy period not an option then? That way you should not
need to shrink the log. Whilst it may not always possible,
I would like to set up systems so your database and tlog
are the correct size and don't require shrinking. It's not
a good practice to perform regular shrinks.
Just a thought, are you perfomrning regular tlog backups?
By the way how big is your database?
Regards
John

Good SQL Server Site?

I've been working with FirebirdSQL and Delphi for some years now. Most
of our new projects will be VS2005 and SQLServer 2000/2005. Can anyone
recommend a good site for learning SQL Server SP language?
For instance, how do I refer to a new row/field inserted or updated in
an after insert/update trigger? In FirebirdSQL it would be
"New.FieldName".
Thanks,
Warm Regards,
Lee
"Upon further investigation it appears that your software is missing
just one thing. It definitely needs more cow bell..."
this is pretty good
http://www.informit.com/guides/conte...rver&seqNum=46
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Lee" <luv2program2000@.yahoo.com> wrote in message
news:uFmuO5dEGHA.3200@.tk2msftngp13.phx.gbl...
>
> I've been working with FirebirdSQL and Delphi for some years now. Most
> of our new projects will be VS2005 and SQLServer 2000/2005. Can anyone
> recommend a good site for learning SQL Server SP language?
> For instance, how do I refer to a new row/field inserted or updated in
> an after insert/update trigger? In FirebirdSQL it would be
> "New.FieldName".
> Thanks,
> --
> Warm Regards,
> Lee
> "Upon further investigation it appears that your software is missing
> just one thing. It definitely needs more cow bell..."

Good Performance Training

I'm looking for a good SQL Server performance training class - I
finally wore my boss down and he gave me $. I've done lots of Oracle
courses in the past but have had a hard time finding a Microsoft
certified course and I just missed TechEd so I was thinking about this
one:
http://www.sqlskills.com/immersion_dbtuning.asp as I hear that
Kimberley Tripp is a good teacher - it was promoted at the last
Chi-SSUG so I guess its ok? What does everyone else think? Are there
other better things on offer? The dates work for me (gotta do a big
release in Sep so the dust'll settle by then :-)
I want an instructor led classroom course so's I can ask questions
about our own systems and design, and it has to be technical to keep me
interested and I hate it when the teacher is just a page ahead of the
class and knows nothing
TonyCar
Senior Programmer/DBA
Midwest Exchange, IL
Kimberly is an extraordinary speaker, you can't miss with her. Besides her,
Kalen Delaney is just as good - check
http://www.solidqualitylearning.com/...nceTuning.htm.
Yes, women rule :-)
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
<carluccit@.hotmail.com> wrote in message
news:cgejoh$upp@.odah37.prod.google.com...
> I'm looking for a good SQL Server performance training class - I
> finally wore my boss down and he gave me $. I've done lots of Oracle
> courses in the past but have had a hard time finding a Microsoft
> certified course and I just missed TechEd so I was thinking about this
> one:
> http://www.sqlskills.com/immersion_dbtuning.asp as I hear that
> Kimberley Tripp is a good teacher - it was promoted at the last
> Chi-SSUG so I guess its ok? What does everyone else think? Are there
> other better things on offer? The dates work for me (gotta do a big
> release in Sep so the dust'll settle by then :-)
> I want an instructor led classroom course so's I can ask questions
> about our own systems and design, and it has to be technical to keep me
> interested and I hate it when the teacher is just a page ahead of the
> class and knows nothing
> TonyCar
> Senior Programmer/DBA
> Midwest Exchange, IL
>
|||I agree with Dejan...
Also consider Scalability Experts, if they are doing anything in your
area... ONe of the SQL MVPs works for them...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<carluccit@.hotmail.com> wrote in message
news:cgejoh$upp@.odah37.prod.google.com...
> I'm looking for a good SQL Server performance training class - I
> finally wore my boss down and he gave me $. I've done lots of Oracle
> courses in the past but have had a hard time finding a Microsoft
> certified course and I just missed TechEd so I was thinking about this
> one:
> http://www.sqlskills.com/immersion_dbtuning.asp as I hear that
> Kimberley Tripp is a good teacher - it was promoted at the last
> Chi-SSUG so I guess its ok? What does everyone else think? Are there
> other better things on offer? The dates work for me (gotta do a big
> release in Sep so the dust'll settle by then :-)
> I want an instructor led classroom course so's I can ask questions
> about our own systems and design, and it has to be technical to keep me
> interested and I hate it when the teacher is just a page ahead of the
> class and knows nothing
> TonyCar
> Senior Programmer/DBA
> Midwest Exchange, IL
>

good integration services book

ive been learning through books online, but i just find learning from a book is better for me. have any of you bought books on integration services and if so , would you recommend them?

I have "Professional SQL Server 2005 Integration Services". I have not used the book extensively as I am currently extracting from an Oracle source into SQL 2005 and then using stored procs to carry out the ETL.

Most of my advanced work is in SSAS and I would recommend "Applied Microsoft Analysis Services 2005" by Teo Lachev.

|||

I agree both books listed previously are excellent. You should also look at "The Microsoft Data Warehouse Toolkit" from Wiley. Much of the book is devoted to SSIS.

Frank

|||

I agree that all three books are must haves.

The MS Data Warehouse toolkit is particularly good if you haven't built a warehouse before, because it concentrates much more on the WHATS rather than the HOWS.

You may also want to consider "The Rational Guide to Scripting SQL Server 2005 Integration Services'.

Its not a must have, but can come in handy and is a quick read.

|||

The book is great and just attended the class taught by the authors of the MS Datawarehous Toolkit.

Highly recommended.

Mark

spaces.msn.com/mgarnerbi

|||Well you can try my book. It's really for the beginners. If you are an advanced user or trying to do some serious stuff this is not for you. However, you may still find some parts usufl. What else I can say I am the author and I have the most sanguine expectations that it is a helpful book. If you liked it send an email: jkrishnaswamy@.comcast.net.
Well, if you did not like it also send me an email.

http://www.packtpub.com/sql-server-integration-services-visual-studio-2005/book

GO Statement

Hi,
I've notied when I execute SQL Transact statements I can do it without
GO Statement. But when I refer to a lot of online documents, I see GO
statements. So from the practice/good coding perspective, when shall I
put GO statement? Why?
Thanks a lot!!
Michael
Michael,
Did you look into BOL before posting the question?
GO (Transact-SQL)
http://msdn2.microsoft.com/en-us/library/ms188037.aspx
AMB
"Michael" wrote:

> Hi,
> I've notied when I execute SQL Transact statements I can do it without
> GO Statement. But when I refer to a lot of online documents, I see GO
> statements. So from the practice/good coding perspective, when shall I
> put GO statement? Why?
> Thanks a lot!!
> Michael
>

Giving only READ permissions to a DB

Hi
I'm having a user that needs to get only READ permissions to one of our
databases. I've created a login for him, and granted him access to the
database. I've then given him db_reader access and deny_db_reader.
Will this be sufficient or is there any additional rights I have to set or
deny? I've verified that he can only read from the database and can't e.g.
perform an update statement, but id there something I haven't thought about?
Regards
Steen
> I'm having a user that needs to get only READ permissions to one of our
> databases. I've created a login for him, and granted him access to the
> database. I've then given him db_reader access and deny_db_reader.
I guess you mean db_denydatawriter.

> Will this be sufficient or is there any additional rights I have to set or
> deny? I've verified that he can only read from the database and can't e.g.
> perform an update statement, but id there something I haven't thought
about?
By default, user has no permissions in a database, so just adding a user to
the db_datareader fixe db role should be enough. Just be careful that the
user is not a member of any other role that has additional permissions and
that you don't give any permissions to the public fixed role (every user is
automatically a member of the public role).
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
|||Why are you negating db_reader access by giving him deny_db_reader?
"Dejan Sarka" wrote:

> I guess you mean db_denydatawriter.
> about?
> By default, user has no permissions in a database, so just adding a user to
> the db_datareader fixe db role should be enough. Just be careful that the
> user is not a member of any other role that has additional permissions and
> that you don't give any permissions to the public fixed role (every user is
> automatically a member of the public role).
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
>
>