Minimally Logged Operations in SQL Server 2005

Hello!
I am trying to confirm what BOL says (
http://msdn2.microsoft.com/en-us/library/ms191244.aspx):
'...Bulk-logging is more efficient than full logging, and it reduces the
possibility of a large-scale bulk operation filling the available
transaction log space during a bulk transaction. However, if the database is
damaged or lost when bulk logging is in effect, you cannot recover the
database to the point of failure.
Note:
Unless a backup is running, minimal logging is used under the simple
recovery model.
...'
Does this mean that BULK-LOGGED recovery mode is more efficient in
terms of logging when database backup is running?
Thanks,
Igor
begin 666 note.gif
M1TE&.#EA"@.`*`+,)`/\$`/]=6L;#QM;3UO_/`(2&A(R.C ```/__SO___P``
M`````````````````````"'Y! $```D`+ `````*``H```0HT,@.Y1 `&Z7T(
AWEIW)!E'C.16G$.2(L-1((5;%D-H@._H+HH>@.,.B*```[
`
endYes, it is especially useful if you want high performance during bcp or bulk
insert operations.
--
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
"imarchenko" <igormarchenko@.hotmail.com> wrote in message
news:elYju2KyHHA.3768@.TK2MSFTNGP06.phx.gbl...
> Hello!
> I am trying to confirm what BOL says (
> http://msdn2.microsoft.com/en-us/library/ms191244.aspx):
> '...Bulk-logging is more efficient than full logging, and it reduces the
> possibility of a large-scale bulk operation filling the available
> transaction log space during a bulk transaction. However, if the database
> is damaged or lost when bulk logging is in effect, you cannot recover the
> database to the point of failure.
> Note:
> Unless a backup is running, minimal logging is used under the simple
> recovery model.
> ...'
> Does this mean that BULK-LOGGED recovery mode is more efficient in
> terms of logging when database backup is running?
> Thanks,
> Igor
>
>|||Hilary,
Sorry for not making my question clear.
I was trying to compare performance/IO footprint of SIMPLE vs.
BULK-LOGGED during backup activities. Our database is in SIMPLE mode (I do
understand the implications of that) and we are contemplating whether we
should switch to BULK-LOGGED to imrpove performance during BACKUP operations
(we are working with multi-terabyte databases). Would you have any comments
on that?
On a similar note, we are doing a lot of bcp into the database. My
assumption was that both BULK-LOGGED and SIMPLE modes would behave in
similar way when it comes to logging during bcp operation. Is this
assumption correct?
Thanks,
Igor
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uhdDaESyHHA.1184@.TK2MSFTNGP04.phx.gbl...
> Yes, it is especially useful if you want high performance during bcp or
> bulk insert operations.
> --
> 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
> "imarchenko" <igormarchenko@.hotmail.com> wrote in message
> news:elYju2KyHHA.3768@.TK2MSFTNGP06.phx.gbl...
>> Hello!
>> I am trying to confirm what BOL says (
>> http://msdn2.microsoft.com/en-us/library/ms191244.aspx):
>> '...Bulk-logging is more efficient than full logging, and it reduces the
>> possibility of a large-scale bulk operation filling the available
>> transaction log space during a bulk transaction. However, if the database
>> is damaged or lost when bulk logging is in effect, you cannot recover the
>> database to the point of failure.
>> Note:
>> Unless a backup is running, minimal logging is used under the simple
>> recovery model.
>> ...'
>> Does this mean that BULK-LOGGED recovery mode is more efficient in
>> terms of logging when database backup is running?
>> Thanks,
>> Igor
>>
>>
>

Minimally Logged Operations in SQL Server 2005

Hello!
I am trying to confirm what BOL says (
http://msdn2.microsoft.com/en-us/library/ms191244.aspx):
'...Bulk-logging is more efficient than full logging, and it reduces the
possibility of a large-scale bulk operation filling the available
transaction log space during a bulk transaction. However, if the database is
damaged or lost when bulk logging is in effect, you cannot recover the
database to the point of failure.
Note:
Unless a backup is running, minimal logging is used under the simple
recovery model.
...'
Does this mean that BULK-LOGGED recovery mode is more efficient in
terms of logging when database backup is running?
Thanks,
Igor
Yes, it is especially useful if you want high performance during bcp or bulk
insert operations.
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
"imarchenko" <igormarchenko@.hotmail.com> wrote in message
news:elYju2KyHHA.3768@.TK2MSFTNGP06.phx.gbl...
> Hello!
> I am trying to confirm what BOL says (
> http://msdn2.microsoft.com/en-us/library/ms191244.aspx):
> '...Bulk-logging is more efficient than full logging, and it reduces the
> possibility of a large-scale bulk operation filling the available
> transaction log space during a bulk transaction. However, if the database
> is damaged or lost when bulk logging is in effect, you cannot recover the
> database to the point of failure.
> Note:
> Unless a backup is running, minimal logging is used under the simple
> recovery model.
> ...'
> Does this mean that BULK-LOGGED recovery mode is more efficient in
> terms of logging when database backup is running?
> Thanks,
> Igor
>
>
|||Hilary,
Sorry for not making my question clear.
I was trying to compare performance/IO footprint of SIMPLE vs.
BULK-LOGGED during backup activities. Our database is in SIMPLE mode (I do
understand the implications of that) and we are contemplating whether we
should switch to BULK-LOGGED to imrpove performance during BACKUP operations
(we are working with multi-terabyte databases). Would you have any comments
on that?
On a similar note, we are doing a lot of bcp into the database. My
assumption was that both BULK-LOGGED and SIMPLE modes would behave in
similar way when it comes to logging during bcp operation. Is this
assumption correct?
Thanks,
Igor
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uhdDaESyHHA.1184@.TK2MSFTNGP04.phx.gbl...
> Yes, it is especially useful if you want high performance during bcp or
> bulk insert operations.
> --
> 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
> "imarchenko" <igormarchenko@.hotmail.com> wrote in message
> news:elYju2KyHHA.3768@.TK2MSFTNGP06.phx.gbl...
>

Minimally Logged Operations in SQL Server 2005

underprocessableYes, it is especially useful if you want high performance during bcp or bulk
insert operations.
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
"imarchenko" <igormarchenko@.hotmail.com> wrote in message
news:elYju2KyHHA.3768@.TK2MSFTNGP06.phx.gbl...
> Hello!
> I am trying to confirm what BOL says (
> http://msdn2.microsoft.com/en-us/library/ms191244.aspx):
> '...Bulk-logging is more efficient than full logging, and it reduces the
> possibility of a large-scale bulk operation filling the available
> transaction log space during a bulk transaction. However, if the database
> is damaged or lost when bulk logging is in effect, you cannot recover the
> database to the point of failure.
> Note:
> Unless a backup is running, minimal logging is used under the simple
> recovery model.
> ...'
> Does this mean that BULK-LOGGED recovery mode is more efficient in
> terms of logging when database backup is running?
> Thanks,
> Igor
>
>|||Hilary,
Sorry for not making my question clear.
I was trying to compare performance/IO footprint of SIMPLE vs.
BULK-LOGGED during backup activities. Our database is in SIMPLE mode (I do
understand the implications of that) and we are contemplating whether we
should switch to BULK-LOGGED to imrpove performance during BACKUP operations
(we are working with multi-terabyte databases). Would you have any comments
on that?
On a similar note, we are doing a lot of bcp into the database. My
assumption was that both BULK-LOGGED and SIMPLE modes would behave in
similar way when it comes to logging during bcp operation. Is this
assumption correct?
Thanks,
Igor
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uhdDaESyHHA.1184@.TK2MSFTNGP04.phx.gbl...
> Yes, it is especially useful if you want high performance during bcp or
> bulk insert operations.
> --
> 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
> "imarchenko" <igormarchenko@.hotmail.com> wrote in message
> news:elYju2KyHHA.3768@.TK2MSFTNGP06.phx.gbl...
>

Migrating to a new server

I currently have SQL running on an server that used to be used for call
center operations. There are many orphaned applications on this server and
we are planning to back up the server, reinstall a freash copy of 2000 server
and SQL 2000.
I have seen there is several ways to migrate data back onto the server,
detach / attach, restore from back up's, etc...
Our data center who is responsible for the maintenance of the server uses a
tool called vertias to back up the SQL databases.
Can anyone tell me the best method of restoring the system?Hi Gary
Usually it will depend on how big the databases are as to how you plan this.
You don't say if you normally back your databases up to disc and then to tape
or use the plug-ins. You also don't say if you are going to reformat the
drives or not!
If you backup to disc then you can use those backups to restore the
databases, providing the drives have not been reformated! If you don't have
backups on disc you could backup to a networked machine or possibly a plugged
in device and then use them to restore from. Restoring from tape will be
possible, but it will probably take significantly longer. You should also
verify the backups (tape or disc) before you remove SQL Server. As an
alternative to backing up you could detach the user databases and re-attach
them, once you have re-installed SQL Server and service packed it (this may
be the quickest method) but having a backup on disc and/or tape will give
you a second/third level of recovery.
John
"GaryC" wrote:
> I currently have SQL running on an server that used to be used for call
> center operations. There are many orphaned applications on this server and
> we are planning to back up the server, reinstall a freash copy of 2000 server
> and SQL 2000.
> I have seen there is several ways to migrate data back onto the server,
> detach / attach, restore from back up's, etc...
> Our data center who is responsible for the maintenance of the server uses a
> tool called vertias to back up the SQL databases.
> Can anyone tell me the best method of restoring the system?|||Gary
http://vyaskn.tripod.com/moving_sql_server.htm
"GaryC" <GaryC@.discussions.microsoft.com> wrote in message
news:DDAE0D2D-B700-474B-95A8-4FC1D80FEFF8@.microsoft.com...
>I currently have SQL running on an server that used to be used for call
> center operations. There are many orphaned applications on this server
> and
> we are planning to back up the server, reinstall a freash copy of 2000
> server
> and SQL 2000.
> I have seen there is several ways to migrate data back onto the server,
> detach / attach, restore from back up's, etc...
> Our data center who is responsible for the maintenance of the server uses
> a
> tool called vertias to back up the SQL databases.
> Can anyone tell me the best method of restoring the system?|||Hi John
I have started with a new company and will be working from home. We did a
back up onto a memory stick of QuickBooks and I want to put the data onto my
QuickBooks at home. I have put the memory stick in but can't read any of the
data can you please tell me how I can do this?
Michelle
"John Bell" wrote:
> Hi Gary
> Usually it will depend on how big the databases are as to how you plan this.
> You don't say if you normally back your databases up to disc and then to tape
> or use the plug-ins. You also don't say if you are going to reformat the
> drives or not!
> If you backup to disc then you can use those backups to restore the
> databases, providing the drives have not been reformated! If you don't have
> backups on disc you could backup to a networked machine or possibly a plugged
> in device and then use them to restore from. Restoring from tape will be
> possible, but it will probably take significantly longer. You should also
> verify the backups (tape or disc) before you remove SQL Server. As an
> alternative to backing up you could detach the user databases and re-attach
> them, once you have re-installed SQL Server and service packed it (this may
> be the quickest method) but having a backup on disc and/or tape will give
> you a second/third level of recovery.
> John
> "GaryC" wrote:
> > I currently have SQL running on an server that used to be used for call
> > center operations. There are many orphaned applications on this server and
> > we are planning to back up the server, reinstall a freash copy of 2000 server
> > and SQL 2000.
> >
> > I have seen there is several ways to migrate data back onto the server,
> > detach / attach, restore from back up's, etc...
> >
> > Our data center who is responsible for the maintenance of the server uses a
> > tool called vertias to back up the SQL databases.
> >
> > Can anyone tell me the best method of restoring the system?|||This is probably the wrong newsgroup for help with Quickbooks or memory
stick issues. You may be better off posting to a Windows newsgroup, or even
checking with www.quickbooks.com for appropriate help forums.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Michelle" <Michelle@.discussions.microsoft.com> wrote in message
news:71DF43A3-8590-4466-9E6D-5B8052ACB8B4@.microsoft.com...
> Hi John
> I have started with a new company and will be working from home. We did a
> back up onto a memory stick of QuickBooks and I want to put the data onto
> my
> QuickBooks at home. I have put the memory stick in but can't read any of
> the
> data can you please tell me how I can do this?
> Michelle
> "John Bell" wrote:
>> Hi Gary
>> Usually it will depend on how big the databases are as to how you plan
>> this.
>> You don't say if you normally back your databases up to disc and then to
>> tape
>> or use the plug-ins. You also don't say if you are going to reformat the
>> drives or not!
>> If you backup to disc then you can use those backups to restore the
>> databases, providing the drives have not been reformated! If you don't
>> have
>> backups on disc you could backup to a networked machine or possibly a
>> plugged
>> in device and then use them to restore from. Restoring from tape will be
>> possible, but it will probably take significantly longer. You should also
>> verify the backups (tape or disc) before you remove SQL Server. As an
>> alternative to backing up you could detach the user databases and
>> re-attach
>> them, once you have re-installed SQL Server and service packed it (this
>> may
>> be the quickest method) but having a backup on disc and/or tape will
>> give
>> you a second/third level of recovery.
>> John
>> "GaryC" wrote:
>> > I currently have SQL running on an server that used to be used for call
>> > center operations. There are many orphaned applications on this server
>> > and
>> > we are planning to back up the server, reinstall a freash copy of 2000
>> > server
>> > and SQL 2000.
>> >
>> > I have seen there is several ways to migrate data back onto the server,
>> > detach / attach, restore from back up's, etc...
>> >
>> > Our data center who is responsible for the maintenance of the server
>> > uses a
>> > tool called vertias to back up the SQL databases.
>> >
>> > Can anyone tell me the best method of restoring the system?|||Hi Michelle
As Arnie has said Quickbooks is not really the forte of the people answering
the questions in these groups, but there may be some things you can try, such
as being able to browse the files on the memory stick with windows explorer.
If this is not possible or if you can see the device and not the files then
there is something wrong with either the device or the method you are using
to copy the files.
If you can see the files you require then you may want to copy them into a
directory on the PC. If the files have to be in a specific directory you may
have to move them there. Finding out what files are currently present in
Quickbooks may help you determine this. I would also backup the PC and the
existing Quickbooks setup before you start to do anything. You may want to
try using Quickbooks to create a new set of files and see what files change.
This may give you some indication of what files are needed.
I don't know if Quickbooks has a open file type of functionality or an
import facility, if it does then read up on these in the manual as it may
help.
HTH
John
"Michelle" wrote:
> Hi John
> I have started with a new company and will be working from home. We did a
> back up onto a memory stick of QuickBooks and I want to put the data onto my
> QuickBooks at home. I have put the memory stick in but can't read any of the
> data can you please tell me how I can do this?
> Michelle
> "John Bell" wrote:
> > Hi Gary
> >
> > Usually it will depend on how big the databases are as to how you plan this.
> > You don't say if you normally back your databases up to disc and then to tape
> > or use the plug-ins. You also don't say if you are going to reformat the
> > drives or not!
> >
> > If you backup to disc then you can use those backups to restore the
> > databases, providing the drives have not been reformated! If you don't have
> > backups on disc you could backup to a networked machine or possibly a plugged
> > in device and then use them to restore from. Restoring from tape will be
> > possible, but it will probably take significantly longer. You should also
> > verify the backups (tape or disc) before you remove SQL Server. As an
> > alternative to backing up you could detach the user databases and re-attach
> > them, once you have re-installed SQL Server and service packed it (this may
> > be the quickest method) but having a backup on disc and/or tape will give
> > you a second/third level of recovery.
> >
> > John
> >
> > "GaryC" wrote:
> >
> > > I currently have SQL running on an server that used to be used for call
> > > center operations. There are many orphaned applications on this server and
> > > we are planning to back up the server, reinstall a freash copy of 2000 server
> > > and SQL 2000.
> > >
> > > I have seen there is several ways to migrate data back onto the server,
> > > detach / attach, restore from back up's, etc...
> > >
> > > Our data center who is responsible for the maintenance of the server uses a
> > > tool called vertias to back up the SQL databases.
> > >
> > > Can anyone tell me the best method of restoring the system?

Migrating to a new server

I currently have SQL running on an server that used to be used for call
center operations. There are many orphaned applications on this server and
we are planning to back up the server, reinstall a freash copy of 2000 serve
r
and SQL 2000.
I have seen there is several ways to migrate data back onto the server,
detach / attach, restore from back up's, etc...
Our data center who is responsible for the maintenance of the server uses a
tool called vertias to back up the SQL databases.
Can anyone tell me the best method of restoring the system?Hi Gary
Usually it will depend on how big the databases are as to how you plan this.
You don't say if you normally back your databases up to disc and then to tap
e
or use the plug-ins. You also don't say if you are going to reformat the
drives or not!
If you backup to disc then you can use those backups to restore the
databases, providing the drives have not been reformated! If you don't have
backups on disc you could backup to a networked machine or possibly a plugge
d
in device and then use them to restore from. Restoring from tape will be
possible, but it will probably take significantly longer. You should also
verify the backups (tape or disc) before you remove SQL Server. As an
alternative to backing up you could detach the user databases and re-attach
them, once you have re-installed SQL Server and service packed it (this may
be the quickest method) but having a backup on disc and/or tape will give
you a second/third level of recovery.
John
"GaryC" wrote:

> I currently have SQL running on an server that used to be used for call
> center operations. There are many orphaned applications on this server an
d
> we are planning to back up the server, reinstall a freash copy of 2000 ser
ver
> and SQL 2000.
> I have seen there is several ways to migrate data back onto the server,
> detach / attach, restore from back up's, etc...
> Our data center who is responsible for the maintenance of the server uses
a
> tool called vertias to back up the SQL databases.
> Can anyone tell me the best method of restoring the system?|||Gary
http://vyaskn.tripod.com/moving_sql_server.htm
"GaryC" <GaryC@.discussions.microsoft.com> wrote in message
news:DDAE0D2D-B700-474B-95A8-4FC1D80FEFF8@.microsoft.com...
>I currently have SQL running on an server that used to be used for call
> center operations. There are many orphaned applications on this server
> and
> we are planning to back up the server, reinstall a freash copy of 2000
> server
> and SQL 2000.
> I have seen there is several ways to migrate data back onto the server,
> detach / attach, restore from back up's, etc...
> Our data center who is responsible for the maintenance of the server uses
> a
> tool called vertias to back up the SQL databases.
> Can anyone tell me the best method of restoring the system?|||Hi John
I have started with a new company and will be working from home. We did a
back up onto a memory stick of QuickBooks and I want to put the data onto my
QuickBooks at home. I have put the memory stick in but can't read any of th
e
data can you please tell me how I can do this?
Michelle
"John Bell" wrote:
[vbcol=seagreen]
> Hi Gary
> Usually it will depend on how big the databases are as to how you plan thi
s.
> You don't say if you normally back your databases up to disc and then to t
ape
> or use the plug-ins. You also don't say if you are going to reformat the
> drives or not!
> If you backup to disc then you can use those backups to restore the
> databases, providing the drives have not been reformated! If you don't hav
e
> backups on disc you could backup to a networked machine or possibly a plug
ged
> in device and then use them to restore from. Restoring from tape will be
> possible, but it will probably take significantly longer. You should also
> verify the backups (tape or disc) before you remove SQL Server. As an
> alternative to backing up you could detach the user databases and re-attac
h
> them, once you have re-installed SQL Server and service packed it (this ma
y
> be the quickest method) but having a backup on disc and/or tape will give
> you a second/third level of recovery.
> John
> "GaryC" wrote:
>|||This is probably the wrong newsgroup for help with Quickbooks or memory
stick issues. You may be better off posting to a Windows newsgroup, or even
checking with www.quickbooks.com for appropriate help forums.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Michelle" <Michelle@.discussions.microsoft.com> wrote in message
news:71DF43A3-8590-4466-9E6D-5B8052ACB8B4@.microsoft.com...[vbcol=seagreen]
> Hi John
> I have started with a new company and will be working from home. We did a
> back up onto a memory stick of QuickBooks and I want to put the data onto
> my
> QuickBooks at home. I have put the memory stick in but can't read any of
> the
> data can you please tell me how I can do this?
> Michelle
> "John Bell" wrote:
>|||Hi Michelle
As Arnie has said Quickbooks is not really the forte of the people answering
the questions in these groups, but there may be some things you can try, suc
h
as being able to browse the files on the memory stick with windows explorer.
If this is not possible or if you can see the device and not the files then
there is something wrong with either the device or the method you are using
to copy the files.
If you can see the files you require then you may want to copy them into a
directory on the PC. If the files have to be in a specific directory you may
have to move them there. Finding out what files are currently present in
Quickbooks may help you determine this. I would also backup the PC and the
existing Quickbooks setup before you start to do anything. You may want to
try using Quickbooks to create a new set of files and see what files change.
This may give you some indication of what files are needed.
I don't know if Quickbooks has a open file type of functionality or an
import facility, if it does then read up on these in the manual as it may
help.
HTH
John
"Michelle" wrote:
[vbcol=seagreen]
> Hi John
> I have started with a new company and will be working from home. We did a
> back up onto a memory stick of QuickBooks and I want to put the data onto
my
> QuickBooks at home. I have put the memory stick in but can't read any of
the
> data can you please tell me how I can do this?
> Michelle
> "John Bell" wrote:
>