Q - Adding a database file

I am looking to add datafiles to a somewhat large db (40gb). If I add the
file - how does it get populated? Or does SQL Server start adding data from
that point forward to the file without balancing it?
Data is added to new files going forward. SQL does not rebalance data
within data files.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"frankm" <frankm@.nospam.postalias> wrote in message
news:usm87CAoEHA.3520@.TK2MSFTNGP11.phx.gbl...
> I am looking to add datafiles to a somewhat large db (40gb). If I add the
> file - how does it get populated? Or does SQL Server start adding data
from
> that point forward to the file without balancing it?
>
|||Thanks ... that helps
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OqkaWMAoEHA.132@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Data is added to new files going forward. SQL does not rebalance data
> within data files.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "frankm" <frankm@.nospam.postalias> wrote in message
> news:usm87CAoEHA.3520@.TK2MSFTNGP11.phx.gbl...
the
> from
>
|||One more thing -
Are there any problems with doing an "add file" to a publisher or subscriber
database?
"frankm" <frankm@.nospam.postalias> wrote in message
news:emSYVPAoEHA.2684@.TK2MSFTNGP11.phx.gbl...
> Thanks ... that helps
>
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:OqkaWMAoEHA.132@.TK2MSFTNGP14.phx.gbl...
> the
>
|||No problems. Replication abstracts everything at the database\filegroup
level. It doesn't care whether a filegroup has 1 or 10 underlying files.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"frankm" <frankm@.nospam.postalias> wrote in message
news:ehYPgkKoEHA.3712@.TK2MSFTNGP15.phx.gbl...
> One more thing -
> Are there any problems with doing an "add file" to a publisher or
subscriber[vbcol=seagreen]
> database?
>
> "frankm" <frankm@.nospam.postalias> wrote in message
> news:emSYVPAoEHA.2684@.TK2MSFTNGP11.phx.gbl...
add[vbcol=seagreen]
data
>
|||Thank you sir...
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:eu650yKoEHA.1300@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> No problems. Replication abstracts everything at the database\filegroup
> level. It doesn't care whether a filegroup has 1 or 10 underlying files.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "frankm" <frankm@.nospam.postalias> wrote in message
> news:ehYPgkKoEHA.3712@.TK2MSFTNGP15.phx.gbl...
> subscriber
data
> add
> data
>

Published Database Log file not growing bigger?

Hi,
My log file on the publisher for the published database, doesnt seem to
grow, its always around 1MB, teh log file settings are set to allow the
file to grow incrementally and everything else seems normal.
After some further investigations I came across an option that should
apparently be set to false ( Truncate Log on Checkpoint).
SELECT DATABASEPROPERTY ('Northwind', 'IsTruncLog')
after running this, I determined that is was in fact set to TRUE. In order
to change it to false, I need to run this procedure
SP_DBOPTION Northwind ,'trunc. log on chkpt.', false
by setting this to false, would this cause any problems with replication
(Merge Replication, with pull subscribers)?
Thanks in advance.
Warren
No, this setting will not affect replication.
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
"Warren Patterson" <des@.newsgroups.nospam> wrote in message
news:%23mTTueTNFHA.3356@.TK2MSFTNGP12.phx.gbl...
> Hi,
> My log file on the publisher for the published database, doesnt seem to
> grow, its always around 1MB, teh log file settings are set to allow the
> file to grow incrementally and everything else seems normal.
> After some further investigations I came across an option that should
> apparently be set to false ( Truncate Log on Checkpoint).
> SELECT DATABASEPROPERTY ('Northwind', 'IsTruncLog')
> after running this, I determined that is was in fact set to TRUE. In
order
> to change it to false, I need to run this procedure
> SP_DBOPTION Northwind ,'trunc. log on chkpt.', false
> by setting this to false, would this cause any problems with replication
> (Merge Replication, with pull subscribers)?
>
> Thanks in advance.
> Warren
>
>
>
>
|||Many Thanks
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:Oqy0c1TNFHA.3156@.TK2MSFTNGP15.phx.gbl...
> No, this setting will not affect replication.
> --
> 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
> "Warren Patterson" <des@.newsgroups.nospam> wrote in message
> news:%23mTTueTNFHA.3356@.TK2MSFTNGP12.phx.gbl...
> order
>