Let's asume we saved a 40 MB file in SQL Server, and 100 people at once will
download it.. can SQL Server handle that?
It's on a dedicated machine, just one server, no load balancing and such.
Hi
It is not clear why you would want to hold such large binary files within
the database. The most likely bottleneck will be your network especially if
you only have one NIC.
John
"the friendly display name" wrote:
> Let's asume we saved a 40 MB file in SQL Server, and 100 people at once will
> download it.. can SQL Server handle that?
> It's on a dedicated machine, just one server, no load balancing and such.
|||It's not in our office, we're hosting externaly. So the network isn't the
problem.
Why are we doing it:
We offer files (self-made programs), the customer needs to be authorized to
be able to download them. We're offering currently over 20 files, each file
is in a certain group.. the customer can be in group 1, group 2, group 3...
and he can only download files, which are in the same group as him.
How to make that just with IIS? OK, forms auth., but you can only lock
certain folders, not files, and you can't do it programmaticaly, just with
web.config.
To offer them over the SQL Server.. I think it's the easiest way. If you
know better ways to do that, I'll listen.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> It is not clear why you would want to hold such large binary files within
> the database. The most likely bottleneck will be your network especially if
> you only have one NIC.
> John
> "the friendly display name" wrote:
|||Well, is SQL Server able to handle so many downloads with such configuration?
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> It is not clear why you would want to hold such large binary files within
> the database. The most likely bottleneck will be your network especially if
> you only have one NIC.
> John
> "the friendly display name" wrote:
|||Hi
It could, but you will have to do your own benchmark on your own servers to
see if your configuration is up to it. Your solution will not be as scalable
as one that only stores pointers in the database and restricting access via
what they can retrieve.
John
"the friendly display name" wrote:
[vbcol=seagreen]
> Well, is SQL Server able to handle so many downloads with such configuration?
> "John Bell" wrote:
Showing posts with label saved. Show all posts
Showing posts with label saved. Show all posts
Wednesday, March 21, 2012
Monday, March 19, 2012
How many binary downloads can SQL Server handle?
Let's asume we saved a 40 MB file in SQL Server, and 100 people at once will
download it.. can SQL Server handle that?
It's on a dedicated machine, just one server, no load balancing and such.Hi
It is not clear why you would want to hold such large binary files within
the database. The most likely bottleneck will be your network especially if
you only have one NIC.
John
"the friendly display name" wrote:
> Let's asume we saved a 40 MB file in SQL Server, and 100 people at once wi
ll
> download it.. can SQL Server handle that?
> It's on a dedicated machine, just one server, no load balancing and such.|||It's not in our office, we're hosting externaly. So the network isn't the
problem.
Why are we doing it:
We offer files (self-made programs), the customer needs to be authorized to
be able to download them. We're offering currently over 20 files, each file
is in a certain group.. the customer can be in group 1, group 2, group 3...
and he can only download files, which are in the same group as him.
How to make that just with IIS? OK, forms auth., but you can only lock
certain folders, not files, and you can't do it programmaticaly, just with
web.config.
To offer them over the SQL Server.. I think it's the easiest way. If you
know better ways to do that, I'll listen.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> It is not clear why you would want to hold such large binary files within
> the database. The most likely bottleneck will be your network especially i
f
> you only have one NIC.
> John
> "the friendly display name" wrote:
>|||Well, is SQL Server able to handle so many downloads with such configuration
?
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> It is not clear why you would want to hold such large binary files within
> the database. The most likely bottleneck will be your network especially i
f
> you only have one NIC.
> John
> "the friendly display name" wrote:
>|||Hi
It could, but you will have to do your own benchmark on your own servers to
see if your configuration is up to it. Your solution will not be as scalable
as one that only stores pointers in the database and restricting access via
what they can retrieve.
John
"the friendly display name" wrote:
[vbcol=seagreen]
> Well, is SQL Server able to handle so many downloads with such configurati
on?
> "John Bell" wrote:
>
download it.. can SQL Server handle that?
It's on a dedicated machine, just one server, no load balancing and such.Hi
It is not clear why you would want to hold such large binary files within
the database. The most likely bottleneck will be your network especially if
you only have one NIC.
John
"the friendly display name" wrote:
> Let's asume we saved a 40 MB file in SQL Server, and 100 people at once wi
ll
> download it.. can SQL Server handle that?
> It's on a dedicated machine, just one server, no load balancing and such.|||It's not in our office, we're hosting externaly. So the network isn't the
problem.
Why are we doing it:
We offer files (self-made programs), the customer needs to be authorized to
be able to download them. We're offering currently over 20 files, each file
is in a certain group.. the customer can be in group 1, group 2, group 3...
and he can only download files, which are in the same group as him.
How to make that just with IIS? OK, forms auth., but you can only lock
certain folders, not files, and you can't do it programmaticaly, just with
web.config.
To offer them over the SQL Server.. I think it's the easiest way. If you
know better ways to do that, I'll listen.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> It is not clear why you would want to hold such large binary files within
> the database. The most likely bottleneck will be your network especially i
f
> you only have one NIC.
> John
> "the friendly display name" wrote:
>|||Well, is SQL Server able to handle so many downloads with such configuration
?
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> It is not clear why you would want to hold such large binary files within
> the database. The most likely bottleneck will be your network especially i
f
> you only have one NIC.
> John
> "the friendly display name" wrote:
>|||Hi
It could, but you will have to do your own benchmark on your own servers to
see if your configuration is up to it. Your solution will not be as scalable
as one that only stores pointers in the database and restricting access via
what they can retrieve.
John
"the friendly display name" wrote:
[vbcol=seagreen]
> Well, is SQL Server able to handle so many downloads with such configurati
on?
> "John Bell" wrote:
>
How many binary downloads can SQL Server handle?
Let's asume we saved a 40 MB file in SQL Server, and 100 people at once will
download it.. can SQL Server handle that?
It's on a dedicated machine, just one server, no load balancing and such.
Hi
It is not clear why you would want to hold such large binary files within
the database. The most likely bottleneck will be your network especially if
you only have one NIC.
John
"the friendly display name" wrote:
> Let's asume we saved a 40 MB file in SQL Server, and 100 people at once will
> download it.. can SQL Server handle that?
> It's on a dedicated machine, just one server, no load balancing and such.
|||It's not in our office, we're hosting externaly. So the network isn't the
problem.
Why are we doing it:
We offer files (self-made programs), the customer needs to be authorized to
be able to download them. We're offering currently over 20 files, each file
is in a certain group.. the customer can be in group 1, group 2, group 3...
and he can only download files, which are in the same group as him.
How to make that just with IIS? OK, forms auth., but you can only lock
certain folders, not files, and you can't do it programmaticaly, just with
web.config.
To offer them over the SQL Server.. I think it's the easiest way. If you
know better ways to do that, I'll listen.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> It is not clear why you would want to hold such large binary files within
> the database. The most likely bottleneck will be your network especially if
> you only have one NIC.
> John
> "the friendly display name" wrote:
|||Well, is SQL Server able to handle so many downloads with such configuration?
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> It is not clear why you would want to hold such large binary files within
> the database. The most likely bottleneck will be your network especially if
> you only have one NIC.
> John
> "the friendly display name" wrote:
|||Hi
It could, but you will have to do your own benchmark on your own servers to
see if your configuration is up to it. Your solution will not be as scalable
as one that only stores pointers in the database and restricting access via
what they can retrieve.
John
"the friendly display name" wrote:
[vbcol=seagreen]
> Well, is SQL Server able to handle so many downloads with such configuration?
> "John Bell" wrote:
download it.. can SQL Server handle that?
It's on a dedicated machine, just one server, no load balancing and such.
Hi
It is not clear why you would want to hold such large binary files within
the database. The most likely bottleneck will be your network especially if
you only have one NIC.
John
"the friendly display name" wrote:
> Let's asume we saved a 40 MB file in SQL Server, and 100 people at once will
> download it.. can SQL Server handle that?
> It's on a dedicated machine, just one server, no load balancing and such.
|||It's not in our office, we're hosting externaly. So the network isn't the
problem.
Why are we doing it:
We offer files (self-made programs), the customer needs to be authorized to
be able to download them. We're offering currently over 20 files, each file
is in a certain group.. the customer can be in group 1, group 2, group 3...
and he can only download files, which are in the same group as him.
How to make that just with IIS? OK, forms auth., but you can only lock
certain folders, not files, and you can't do it programmaticaly, just with
web.config.
To offer them over the SQL Server.. I think it's the easiest way. If you
know better ways to do that, I'll listen.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> It is not clear why you would want to hold such large binary files within
> the database. The most likely bottleneck will be your network especially if
> you only have one NIC.
> John
> "the friendly display name" wrote:
|||Well, is SQL Server able to handle so many downloads with such configuration?
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> It is not clear why you would want to hold such large binary files within
> the database. The most likely bottleneck will be your network especially if
> you only have one NIC.
> John
> "the friendly display name" wrote:
|||Hi
It could, but you will have to do your own benchmark on your own servers to
see if your configuration is up to it. Your solution will not be as scalable
as one that only stores pointers in the database and restricting access via
what they can retrieve.
John
"the friendly display name" wrote:
[vbcol=seagreen]
> Well, is SQL Server able to handle so many downloads with such configuration?
> "John Bell" wrote:
How many binary downloads can SQL Server handle?
Let's asume we saved a 40 MB file in SQL Server, and 100 people at once will
download it.. can SQL Server handle that?
It's on a dedicated machine, just one server, no load balancing and such.Hi
It is not clear why you would want to hold such large binary files within
the database. The most likely bottleneck will be your network especially if
you only have one NIC.
John
"the friendly display name" wrote:
> Let's asume we saved a 40 MB file in SQL Server, and 100 people at once will
> download it.. can SQL Server handle that?
> It's on a dedicated machine, just one server, no load balancing and such.|||It's not in our office, we're hosting externaly. So the network isn't the
problem.
Why are we doing it:
We offer files (self-made programs), the customer needs to be authorized to
be able to download them. We're offering currently over 20 files, each file
is in a certain group.. the customer can be in group 1, group 2, group 3...
and he can only download files, which are in the same group as him.
How to make that just with IIS? OK, forms auth., but you can only lock
certain folders, not files, and you can't do it programmaticaly, just with
web.config.
To offer them over the SQL Server.. I think it's the easiest way. If you
know better ways to do that, I'll listen.
"John Bell" wrote:
> Hi
> It is not clear why you would want to hold such large binary files within
> the database. The most likely bottleneck will be your network especially if
> you only have one NIC.
> John
> "the friendly display name" wrote:
> > Let's asume we saved a 40 MB file in SQL Server, and 100 people at once will
> > download it.. can SQL Server handle that?
> >
> > It's on a dedicated machine, just one server, no load balancing and such.|||Well, is SQL Server able to handle so many downloads with such configuration?
"John Bell" wrote:
> Hi
> It is not clear why you would want to hold such large binary files within
> the database. The most likely bottleneck will be your network especially if
> you only have one NIC.
> John
> "the friendly display name" wrote:
> > Let's asume we saved a 40 MB file in SQL Server, and 100 people at once will
> > download it.. can SQL Server handle that?
> >
> > It's on a dedicated machine, just one server, no load balancing and such.|||Hi
It could, but you will have to do your own benchmark on your own servers to
see if your configuration is up to it. Your solution will not be as scalable
as one that only stores pointers in the database and restricting access via
what they can retrieve.
John
"the friendly display name" wrote:
> Well, is SQL Server able to handle so many downloads with such configuration?
> "John Bell" wrote:
> > Hi
> >
> > It is not clear why you would want to hold such large binary files within
> > the database. The most likely bottleneck will be your network especially if
> > you only have one NIC.
> >
> > John
> >
> > "the friendly display name" wrote:
> >
> > > Let's asume we saved a 40 MB file in SQL Server, and 100 people at once will
> > > download it.. can SQL Server handle that?
> > >
> > > It's on a dedicated machine, just one server, no load balancing and such.
download it.. can SQL Server handle that?
It's on a dedicated machine, just one server, no load balancing and such.Hi
It is not clear why you would want to hold such large binary files within
the database. The most likely bottleneck will be your network especially if
you only have one NIC.
John
"the friendly display name" wrote:
> Let's asume we saved a 40 MB file in SQL Server, and 100 people at once will
> download it.. can SQL Server handle that?
> It's on a dedicated machine, just one server, no load balancing and such.|||It's not in our office, we're hosting externaly. So the network isn't the
problem.
Why are we doing it:
We offer files (self-made programs), the customer needs to be authorized to
be able to download them. We're offering currently over 20 files, each file
is in a certain group.. the customer can be in group 1, group 2, group 3...
and he can only download files, which are in the same group as him.
How to make that just with IIS? OK, forms auth., but you can only lock
certain folders, not files, and you can't do it programmaticaly, just with
web.config.
To offer them over the SQL Server.. I think it's the easiest way. If you
know better ways to do that, I'll listen.
"John Bell" wrote:
> Hi
> It is not clear why you would want to hold such large binary files within
> the database. The most likely bottleneck will be your network especially if
> you only have one NIC.
> John
> "the friendly display name" wrote:
> > Let's asume we saved a 40 MB file in SQL Server, and 100 people at once will
> > download it.. can SQL Server handle that?
> >
> > It's on a dedicated machine, just one server, no load balancing and such.|||Well, is SQL Server able to handle so many downloads with such configuration?
"John Bell" wrote:
> Hi
> It is not clear why you would want to hold such large binary files within
> the database. The most likely bottleneck will be your network especially if
> you only have one NIC.
> John
> "the friendly display name" wrote:
> > Let's asume we saved a 40 MB file in SQL Server, and 100 people at once will
> > download it.. can SQL Server handle that?
> >
> > It's on a dedicated machine, just one server, no load balancing and such.|||Hi
It could, but you will have to do your own benchmark on your own servers to
see if your configuration is up to it. Your solution will not be as scalable
as one that only stores pointers in the database and restricting access via
what they can retrieve.
John
"the friendly display name" wrote:
> Well, is SQL Server able to handle so many downloads with such configuration?
> "John Bell" wrote:
> > Hi
> >
> > It is not clear why you would want to hold such large binary files within
> > the database. The most likely bottleneck will be your network especially if
> > you only have one NIC.
> >
> > John
> >
> > "the friendly display name" wrote:
> >
> > > Let's asume we saved a 40 MB file in SQL Server, and 100 people at once will
> > > download it.. can SQL Server handle that?
> > >
> > > It's on a dedicated machine, just one server, no load balancing and such.
Wednesday, March 7, 2012
How is SQL Server Loosing Saved Data?
SQL Server Records that I saved yesterday do not keep the saved data.
When I browse the saved records the next day the saved information is lost.
Is there a way to detect what is causing this?
So many things could be the cause, but the first thing that comes to mind is: are you working within a transaction? If you start the day with a BEGIN TRAN and forget to end with a COMMIT TRAN, Sql Server's going to roll back your work.Are you backing up your database daily?
Are you working in some development environment that is restored from a prior backup every night?
How are you editing the data that you are creating? and how are you "browsing" your saved records ?
Friday, February 24, 2012
how i can save byte array in database?
hi all
i have Byte Array like this:
dim Arr(388,8) as Byte
its working good in my application, but after i close my application all
data saved in this array is lost.
i need save all data from this array to Database (MDB or SQL), then after i
run application again i load data from Database to my Array Variable.
how i can do that?
its byte aray.
Best Regards
Tark M. Siala
Software Development
INTERNATIONAL COMPUTER CENTER (ICC.Networking)
Mobile: +218-91-3125900
E-Mail: tarksiala@.icc-libya.com
Messenger: tarksiala@.hotmail.com
Web Page: http://www.icc-libya.com
Blog: http://spaces.msn.com/tarksiala
======================================
You can save these values in a Blob field
regards
Michel Posseth [MCP]
"Tark Siala" <tarksiala@.icc-libya.com> wrote in message
news:O%23GSIoIQGHA.3872@.TK2MSFTNGP15.phx.gbl...
> hi all
> i have Byte Array like this:
> dim Arr(388,8) as Byte
> its working good in my application, but after i close my application all
> data saved in this array is lost.
> i need save all data from this array to Database (MDB or SQL), then after
> i run application again i load data from Database to my Array Variable.
> how i can do that?
> its byte aray.
> --
> Best Regards
> Tark M. Siala
> Software Development
> INTERNATIONAL COMPUTER CENTER (ICC.Networking)
> Mobile: +218-91-3125900
> E-Mail: tarksiala@.icc-libya.com
> Messenger: tarksiala@.hotmail.com
> Web Page: http://www.icc-libya.com
> Blog: http://spaces.msn.com/tarksiala
> ======================================
>
|||hi
thanks
but i know how i can working with Blob to save Pictures, but how i can
working with Blob to save (Byte Array)?
Best Regards
Tark M. Siala
Development Manager
INTERNATIONAL COMPUTER CENTER (ICC.Networking)
Mobile: +218-91-3125900
E-Mail: tarksiala@.icc-libya.com
Messenger: tarksiala@.hotmail.com
Web Page: http://www.icc-libya.com
Blog: http://spaces.msn.com/tarksiala
======================================
"m.posseth" <michelp@.nohausystems.nl> wrote in message
news:uomlDeQQGHA.2012@.TK2MSFTNGP14.phx.gbl...
> You can save these values in a Blob field
> regards
> Michel Posseth [MCP]
>
>
>
> "Tark Siala" <tarksiala@.icc-libya.com> wrote in message
> news:O%23GSIoIQGHA.3872@.TK2MSFTNGP15.phx.gbl...
>
i have Byte Array like this:
dim Arr(388,8) as Byte
its working good in my application, but after i close my application all
data saved in this array is lost.
i need save all data from this array to Database (MDB or SQL), then after i
run application again i load data from Database to my Array Variable.
how i can do that?
its byte aray.
Best Regards
Tark M. Siala
Software Development
INTERNATIONAL COMPUTER CENTER (ICC.Networking)
Mobile: +218-91-3125900
E-Mail: tarksiala@.icc-libya.com
Messenger: tarksiala@.hotmail.com
Web Page: http://www.icc-libya.com
Blog: http://spaces.msn.com/tarksiala
======================================
You can save these values in a Blob field
regards
Michel Posseth [MCP]
"Tark Siala" <tarksiala@.icc-libya.com> wrote in message
news:O%23GSIoIQGHA.3872@.TK2MSFTNGP15.phx.gbl...
> hi all
> i have Byte Array like this:
> dim Arr(388,8) as Byte
> its working good in my application, but after i close my application all
> data saved in this array is lost.
> i need save all data from this array to Database (MDB or SQL), then after
> i run application again i load data from Database to my Array Variable.
> how i can do that?
> its byte aray.
> --
> Best Regards
> Tark M. Siala
> Software Development
> INTERNATIONAL COMPUTER CENTER (ICC.Networking)
> Mobile: +218-91-3125900
> E-Mail: tarksiala@.icc-libya.com
> Messenger: tarksiala@.hotmail.com
> Web Page: http://www.icc-libya.com
> Blog: http://spaces.msn.com/tarksiala
> ======================================
>
|||hi
thanks
but i know how i can working with Blob to save Pictures, but how i can
working with Blob to save (Byte Array)?
Best Regards
Tark M. Siala
Development Manager
INTERNATIONAL COMPUTER CENTER (ICC.Networking)
Mobile: +218-91-3125900
E-Mail: tarksiala@.icc-libya.com
Messenger: tarksiala@.hotmail.com
Web Page: http://www.icc-libya.com
Blog: http://spaces.msn.com/tarksiala
======================================
"m.posseth" <michelp@.nohausystems.nl> wrote in message
news:uomlDeQQGHA.2012@.TK2MSFTNGP14.phx.gbl...
> You can save these values in a Blob field
> regards
> Michel Posseth [MCP]
>
>
>
> "Tark Siala" <tarksiala@.icc-libya.com> wrote in message
> news:O%23GSIoIQGHA.3872@.TK2MSFTNGP15.phx.gbl...
>
Sunday, February 19, 2012
How full backup work ?
that what happens if during a full backup a transaction is started or a
transaction is running?
Data modified will be saved ?
It exists a microsoft document that explain how full backup work ?
ThanksThe full backup will contain ALL of the transactions which ended PRIOR to
the completion of the backup. This is because right before the end of the
backup, it goes back to the log and captures the changes made during the
backup.
--
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
"andrea favero" <andreafavero@.discussions.microsoft.com> wrote in message
news:052B33CA-065C-4A46-9CBB-0B5CEA2DE933@.microsoft.com...
> that what happens if during a full backup a transaction is started or a
> transaction is running?
> Data modified will be saved ?
> It exists a microsoft document that explain how full backup work ?
> Thanks|||Where I can find documentation that explain in deep "how work full backup" ?
Thanks
"Wayne Snyder" wrote:
> The full backup will contain ALL of the transactions which ended PRIOR to
> the completion of the backup. This is because right before the end of the
> backup, it goes back to the log and captures the changes made during the
> backup.
> --
> 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
> "andrea favero" <andreafavero@.discussions.microsoft.com> wrote in message
> news:052B33CA-065C-4A46-9CBB-0B5CEA2DE933@.microsoft.com...
> > that what happens if during a full backup a transaction is started or a
> > transaction is running?
> > Data modified will be saved ?
> > It exists a microsoft document that explain how full backup work ?
> >
> > Thanks
>
>
transaction is running?
Data modified will be saved ?
It exists a microsoft document that explain how full backup work ?
ThanksThe full backup will contain ALL of the transactions which ended PRIOR to
the completion of the backup. This is because right before the end of the
backup, it goes back to the log and captures the changes made during the
backup.
--
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
"andrea favero" <andreafavero@.discussions.microsoft.com> wrote in message
news:052B33CA-065C-4A46-9CBB-0B5CEA2DE933@.microsoft.com...
> that what happens if during a full backup a transaction is started or a
> transaction is running?
> Data modified will be saved ?
> It exists a microsoft document that explain how full backup work ?
> Thanks|||Where I can find documentation that explain in deep "how work full backup" ?
Thanks
"Wayne Snyder" wrote:
> The full backup will contain ALL of the transactions which ended PRIOR to
> the completion of the backup. This is because right before the end of the
> backup, it goes back to the log and captures the changes made during the
> backup.
> --
> 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
> "andrea favero" <andreafavero@.discussions.microsoft.com> wrote in message
> news:052B33CA-065C-4A46-9CBB-0B5CEA2DE933@.microsoft.com...
> > that what happens if during a full backup a transaction is started or a
> > transaction is running?
> > Data modified will be saved ?
> > It exists a microsoft document that explain how full backup work ?
> >
> > Thanks
>
>
How full backup work ?
that what happens if during a full backup a transaction is started or a
transaction is running?
Data modified will be saved ?
It exists a microsoft document that explain how full backup work ?
Thanks
The full backup will contain ALL of the transactions which ended PRIOR to
the completion of the backup. This is because right before the end of the
backup, it goes back to the log and captures the changes made during the
backup.
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
"andrea favero" <andreafavero@.discussions.microsoft.com> wrote in message
news:052B33CA-065C-4A46-9CBB-0B5CEA2DE933@.microsoft.com...
> that what happens if during a full backup a transaction is started or a
> transaction is running?
> Data modified will be saved ?
> It exists a microsoft document that explain how full backup work ?
> Thanks
|||Where I can find documentation that explain in deep "how work full backup" ?
Thanks
"Wayne Snyder" wrote:
> The full backup will contain ALL of the transactions which ended PRIOR to
> the completion of the backup. This is because right before the end of the
> backup, it goes back to the log and captures the changes made during the
> backup.
> --
> 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
> "andrea favero" <andreafavero@.discussions.microsoft.com> wrote in message
> news:052B33CA-065C-4A46-9CBB-0B5CEA2DE933@.microsoft.com...
>
>
transaction is running?
Data modified will be saved ?
It exists a microsoft document that explain how full backup work ?
Thanks
The full backup will contain ALL of the transactions which ended PRIOR to
the completion of the backup. This is because right before the end of the
backup, it goes back to the log and captures the changes made during the
backup.
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
"andrea favero" <andreafavero@.discussions.microsoft.com> wrote in message
news:052B33CA-065C-4A46-9CBB-0B5CEA2DE933@.microsoft.com...
> that what happens if during a full backup a transaction is started or a
> transaction is running?
> Data modified will be saved ?
> It exists a microsoft document that explain how full backup work ?
> Thanks
|||Where I can find documentation that explain in deep "how work full backup" ?
Thanks
"Wayne Snyder" wrote:
> The full backup will contain ALL of the transactions which ended PRIOR to
> the completion of the backup. This is because right before the end of the
> backup, it goes back to the log and captures the changes made during the
> backup.
> --
> 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
> "andrea favero" <andreafavero@.discussions.microsoft.com> wrote in message
> news:052B33CA-065C-4A46-9CBB-0B5CEA2DE933@.microsoft.com...
>
>
Labels:
atransaction,
backup,
database,
exists,
microsoft,
modified,
mysql,
oracle,
runningdata,
saved,
server,
sql,
transaction
How full backup work ?
that what happens if during a full backup a transaction is started or a
transaction is running?
Data modified will be saved ?
It exists a microsoft document that explain how full backup work ?
ThanksThe full backup will contain ALL of the transactions which ended PRIOR to
the completion of the backup. This is because right before the end of the
backup, it goes back to the log and captures the changes made during the
backup.
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
"andrea favero" <andreafavero@.discussions.microsoft.com> wrote in message
news:052B33CA-065C-4A46-9CBB-0B5CEA2DE933@.microsoft.com...
> that what happens if during a full backup a transaction is started or a
> transaction is running?
> Data modified will be saved ?
> It exists a microsoft document that explain how full backup work ?
> Thanks|||Where I can find documentation that explain in deep "how work full backup" ?
Thanks
"Wayne Snyder" wrote:
> The full backup will contain ALL of the transactions which ended PRIOR to
> the completion of the backup. This is because right before the end of the
> backup, it goes back to the log and captures the changes made during the
> backup.
> --
> 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
> "andrea favero" <andreafavero@.discussions.microsoft.com> wrote in message
> news:052B33CA-065C-4A46-9CBB-0B5CEA2DE933@.microsoft.com...
>
>
transaction is running?
Data modified will be saved ?
It exists a microsoft document that explain how full backup work ?
ThanksThe full backup will contain ALL of the transactions which ended PRIOR to
the completion of the backup. This is because right before the end of the
backup, it goes back to the log and captures the changes made during the
backup.
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
"andrea favero" <andreafavero@.discussions.microsoft.com> wrote in message
news:052B33CA-065C-4A46-9CBB-0B5CEA2DE933@.microsoft.com...
> that what happens if during a full backup a transaction is started or a
> transaction is running?
> Data modified will be saved ?
> It exists a microsoft document that explain how full backup work ?
> Thanks|||Where I can find documentation that explain in deep "how work full backup" ?
Thanks
"Wayne Snyder" wrote:
> The full backup will contain ALL of the transactions which ended PRIOR to
> the completion of the backup. This is because right before the end of the
> backup, it goes back to the log and captures the changes made during the
> backup.
> --
> 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
> "andrea favero" <andreafavero@.discussions.microsoft.com> wrote in message
> news:052B33CA-065C-4A46-9CBB-0B5CEA2DE933@.microsoft.com...
>
>
Labels:
atransaction,
backup,
database,
exists,
microsoft,
modified,
mysql,
oracle,
runningdata,
saved,
server,
sql,
transaction
Subscribe to:
Posts (Atom)