Hi. bit of a newbie question. My predecessor set up maintenance plans in
SQL 2000 to back up databases and tranlogs (two separate plans.) The
database backup runs nightly. The tranlog backups run on the half-hour
during busines hours. In the folder where the backups are stored, there are
many tranlog backup filess. They are not being purged as designed in the
maint plan (there is a statement in the job step that says delete after 2
days.) Two questions: why are the tranlog backup files not being purged as
expected, and how do I know which log backup files I can delete manaually?
Thanks.Coop wrote:
> Hi. bit of a newbie question. My predecessor set up maintenance plans in
> SQL 2000 to back up databases and tranlogs (two separate plans.) The
> database backup runs nightly. The tranlog backups run on the half-hour
> during busines hours. In the folder where the backups are stored, there are
> many tranlog backup filess. They are not being purged as designed in the
> maint plan (there is a statement in the job step that says delete after 2
> days.) Two questions: why are the tranlog backup files not being purged as
> expected, and how do I know which log backup files I can delete manaually?
Q1: if the logs aren't named with the same rules as the maintplan, then
the agent won't consider them to be 'old'
Q2: as long as you don't need to playback between full backups (or if
you have copies on tape or elsewhere), you should be able to safely
delete any tranlog bkup files that preceed the timestamp for your latest
full backup file.|||Q1: Also, this can happen if the log backup plan includes databases in simple recovery model.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"horseradish" <millardjk@.gmail.com> wrote in message news:uCD1wKYqHHA.3484@.TK2MSFTNGP05.phx.gbl...
> Coop wrote:
>> Hi. bit of a newbie question. My predecessor set up maintenance plans in
>> SQL 2000 to back up databases and tranlogs (two separate plans.) The
>> database backup runs nightly. The tranlog backups run on the half-hour
>> during busines hours. In the folder where the backups are stored, there are
>> many tranlog backup filess. They are not being purged as designed in the
>> maint plan (there is a statement in the job step that says delete after 2
>> days.) Two questions: why are the tranlog backup files not being purged as
>> expected, and how do I know which log backup files I can delete manaually?
> Q1: if the logs aren't named with the same rules as the maintplan, then
> the agent won't consider them to be 'old'
> Q2: as long as you don't need to playback between full backups (or if
> you have copies on tape or elsewhere), you should be able to safely
> delete any tranlog bkup files that preceed the timestamp for your latest
> full backup file.
Showing posts with label back. Show all posts
Showing posts with label back. Show all posts
Wednesday, March 28, 2012
OK to delete tranlog backups?
Hi. bit of a newbie question. My predecessor set up maintenance plans in
SQL 2000 to back up databases and tranlogs (two separate plans.) The
database backup runs nightly. The tranlog backups run on the half-hour
during busines hours. In the folder where the backups are stored, there are
many tranlog backup filess. They are not being purged as designed in the
maint plan (there is a statement in the job step that says delete after 2
days.) Two questions: why are the tranlog backup files not being purged as
expected, and how do I know which log backup files I can delete manaually?
Thanks.
Coop wrote:
> Hi. bit of a newbie question. My predecessor set up maintenance plans in
> SQL 2000 to back up databases and tranlogs (two separate plans.) The
> database backup runs nightly. The tranlog backups run on the half-hour
> during busines hours. In the folder where the backups are stored, there are
> many tranlog backup filess. They are not being purged as designed in the
> maint plan (there is a statement in the job step that says delete after 2
> days.) Two questions: why are the tranlog backup files not being purged as
> expected, and how do I know which log backup files I can delete manaually?
Q1: if the logs aren't named with the same rules as the maintplan, then
the agent won't consider them to be 'old'
Q2: as long as you don't need to playback between full backups (or if
you have copies on tape or elsewhere), you should be able to safely
delete any tranlog bkup files that preceed the timestamp for your latest
full backup file.
|||Q1: Also, this can happen if the log backup plan includes databases in simple recovery model.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"horseradish" <millardjk@.gmail.com> wrote in message news:uCD1wKYqHHA.3484@.TK2MSFTNGP05.phx.gbl...
> Coop wrote:
> Q1: if the logs aren't named with the same rules as the maintplan, then
> the agent won't consider them to be 'old'
> Q2: as long as you don't need to playback between full backups (or if
> you have copies on tape or elsewhere), you should be able to safely
> delete any tranlog bkup files that preceed the timestamp for your latest
> full backup file.
SQL 2000 to back up databases and tranlogs (two separate plans.) The
database backup runs nightly. The tranlog backups run on the half-hour
during busines hours. In the folder where the backups are stored, there are
many tranlog backup filess. They are not being purged as designed in the
maint plan (there is a statement in the job step that says delete after 2
days.) Two questions: why are the tranlog backup files not being purged as
expected, and how do I know which log backup files I can delete manaually?
Thanks.
Coop wrote:
> Hi. bit of a newbie question. My predecessor set up maintenance plans in
> SQL 2000 to back up databases and tranlogs (two separate plans.) The
> database backup runs nightly. The tranlog backups run on the half-hour
> during busines hours. In the folder where the backups are stored, there are
> many tranlog backup filess. They are not being purged as designed in the
> maint plan (there is a statement in the job step that says delete after 2
> days.) Two questions: why are the tranlog backup files not being purged as
> expected, and how do I know which log backup files I can delete manaually?
Q1: if the logs aren't named with the same rules as the maintplan, then
the agent won't consider them to be 'old'
Q2: as long as you don't need to playback between full backups (or if
you have copies on tape or elsewhere), you should be able to safely
delete any tranlog bkup files that preceed the timestamp for your latest
full backup file.
|||Q1: Also, this can happen if the log backup plan includes databases in simple recovery model.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"horseradish" <millardjk@.gmail.com> wrote in message news:uCD1wKYqHHA.3484@.TK2MSFTNGP05.phx.gbl...
> Coop wrote:
> Q1: if the logs aren't named with the same rules as the maintplan, then
> the agent won't consider them to be 'old'
> Q2: as long as you don't need to playback between full backups (or if
> you have copies on tape or elsewhere), you should be able to safely
> delete any tranlog bkup files that preceed the timestamp for your latest
> full backup file.
OK to delete tranlog backups?
Hi. bit of a newbie question. My predecessor set up maintenance plans in
SQL 2000 to back up databases and tranlogs (two separate plans.) The
database backup runs nightly. The tranlog backups run on the half-hour
during busines hours. In the folder where the backups are stored, there are
many tranlog backup filess. They are not being purged as designed in the
maint plan (there is a statement in the job step that says delete after 2
days.) Two questions: why are the tranlog backup files not being purged as
expected, and how do I know which log backup files I can delete manaually?
Thanks.Coop wrote:
> Hi. bit of a newbie question. My predecessor set up maintenance plans in
> SQL 2000 to back up databases and tranlogs (two separate plans.) The
> database backup runs nightly. The tranlog backups run on the half-hour
> during busines hours. In the folder where the backups are stored, there a
re
> many tranlog backup filess. They are not being purged as designed in the
> maint plan (there is a statement in the job step that says delete after 2
> days.) Two questions: why are the tranlog backup files not being purged
as
> expected, and how do I know which log backup files I can delete manaually?
Q1: if the logs aren't named with the same rules as the maintplan, then
the agent won't consider them to be 'old'
Q2: as long as you don't need to playback between full backups (or if
you have copies on tape or elsewhere), you should be able to safely
delete any tranlog bkup files that preceed the timestamp for your latest
full backup file.|||Q1: Also, this can happen if the log backup plan includes databases in simpl
e recovery model.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"horseradish" <millardjk@.gmail.com> wrote in message news:uCD1wKYqHHA.3484@.TK2MSFTNGP05.phx.
gbl...
> Coop wrote:
> Q1: if the logs aren't named with the same rules as the maintplan, then
> the agent won't consider them to be 'old'
> Q2: as long as you don't need to playback between full backups (or if
> you have copies on tape or elsewhere), you should be able to safely
> delete any tranlog bkup files that preceed the timestamp for your latest
> full backup file.sql
SQL 2000 to back up databases and tranlogs (two separate plans.) The
database backup runs nightly. The tranlog backups run on the half-hour
during busines hours. In the folder where the backups are stored, there are
many tranlog backup filess. They are not being purged as designed in the
maint plan (there is a statement in the job step that says delete after 2
days.) Two questions: why are the tranlog backup files not being purged as
expected, and how do I know which log backup files I can delete manaually?
Thanks.Coop wrote:
> Hi. bit of a newbie question. My predecessor set up maintenance plans in
> SQL 2000 to back up databases and tranlogs (two separate plans.) The
> database backup runs nightly. The tranlog backups run on the half-hour
> during busines hours. In the folder where the backups are stored, there a
re
> many tranlog backup filess. They are not being purged as designed in the
> maint plan (there is a statement in the job step that says delete after 2
> days.) Two questions: why are the tranlog backup files not being purged
as
> expected, and how do I know which log backup files I can delete manaually?
Q1: if the logs aren't named with the same rules as the maintplan, then
the agent won't consider them to be 'old'
Q2: as long as you don't need to playback between full backups (or if
you have copies on tape or elsewhere), you should be able to safely
delete any tranlog bkup files that preceed the timestamp for your latest
full backup file.|||Q1: Also, this can happen if the log backup plan includes databases in simpl
e recovery model.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"horseradish" <millardjk@.gmail.com> wrote in message news:uCD1wKYqHHA.3484@.TK2MSFTNGP05.phx.
gbl...
> Coop wrote:
> Q1: if the logs aren't named with the same rules as the maintplan, then
> the agent won't consider them to be 'old'
> Q2: as long as you don't need to playback between full backups (or if
> you have copies on tape or elsewhere), you should be able to safely
> delete any tranlog bkup files that preceed the timestamp for your latest
> full backup file.sql
Monday, March 26, 2012
Offline use
Hi
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regards
use merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
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
|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> 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
>
|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
>
|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
David Portas
SQL Server MVP
|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
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
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make this
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regards
use merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
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
|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> 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
>
|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
>
|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
David Portas
SQL Server MVP
|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
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
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make this
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>
Offline use
Hi
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regards
use merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
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
|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> 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
>
|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
>
|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
David Portas
SQL Server MVP
|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
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
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make this
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>
sql
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regards
use merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
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
|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> 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
>
|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
>
|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
David Portas
SQL Server MVP
|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
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
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make this
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>
sql
Offline use
Hi
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regardsuse merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
--
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|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegroups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> 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
>|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegroups.com...
> > use merge replication to MSDE databases, create pull subscriptions
> > managed by Windows Synchronization Manager.
> >
> > --
> > 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
> >
>
>|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
--
David Portas
SQL Server MVP
--|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
--
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
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegroups.com...
>> use merge replication to MSDE databases, create pull subscriptions
>> managed by Windows Synchronization Manager.
>> --
>> 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
>|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make this
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regardsuse merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
--
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|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegroups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> 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
>|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegroups.com...
> > use merge replication to MSDE databases, create pull subscriptions
> > managed by Windows Synchronization Manager.
> >
> > --
> > 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
> >
>
>|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
--
David Portas
SQL Server MVP
--|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
--
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
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegroups.com...
>> use merge replication to MSDE databases, create pull subscriptions
>> managed by Windows Synchronization Manager.
>> --
>> 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
>|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make this
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>
Offline use
Hi
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regards
use merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
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
|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> 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
>
|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
>
|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
David Portas
SQL Server MVP
|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
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
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make this
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regards
use merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
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
|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> 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
>
|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
>
|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
David Portas
SQL Server MVP
|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
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
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make this
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>
Offline use
Hi
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regards
use merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
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
|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> 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
>
|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
>
|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
David Portas
SQL Server MVP
|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
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
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make this
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regards
use merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
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
|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> 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
>
|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
>
|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
David Portas
SQL Server MVP
|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
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
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make this
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>
Offline use
Hi
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regards
use merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
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
|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> 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
>
|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
>
|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
David Portas
SQL Server MVP
|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
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
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make this
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regards
use merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
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
|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> 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
>
|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
>
|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
David Portas
SQL Server MVP
|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
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
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegr oups.com...
>
|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make this
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>
Offline use
Hi
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regardsuse merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
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|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegroups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> 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
>|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegroups.com...
>
>|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
David Portas
SQL Server MVP
--|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
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
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegroups.com...
>|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make thi
s
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>sql
We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server copy. Seems like
a reasonable requirement. The question is; what do I need to do to make this
happen? Do I need to switch the backend to sql server? Front end to vb or
something like that? Anything else? How do other people do this?
Thanks
Regardsuse merge replication to MSDE databases, create pull subscriptions
managed by Windows Synchronization Manager.
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|||Is this reliable "enough"?
Regards
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:1114135809.601906.238980@.o13g2000cwo.googlegroups.com...
> use merge replication to MSDE databases, create pull subscriptions
> managed by Windows Synchronization Manager.
> --
> 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
>|||Hi
If architected correclty, it works perfectly.
But, considering it is offline, there is always a small chance that you
loose data. The device can be lost or fail before you have the opportunity
upload the data. If you need 100% guarantee that the data gets to your DB,
you have to do it online.
Regards
Mike
"John" wrote:
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegroups.com...
>
>|||> Is this reliable "enough"?
Compared to using Access Jet in a shared environment? Almost certainly!
David Portas
SQL Server MVP
--|||Yes, Kratft Foods/Nabisco has a solution using this only to hand helds
running SQL CE with IIRC 1400 truck drivers. Their fleet distribution
network is built on this. Its reliable enough for them.
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
"John" <John@.nospam.infovis.co.uk> wrote in message
news:u%23eUINxRFHA.3972@.TK2MSFTNGP14.phx.gbl...
> Is this reliable "enough"?
> Regards
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:1114135809.601906.238980@.o13g2000cwo.googlegroups.com...
>|||I'd move to a SQL server (or MSDE) and .Net solution.
ADO.Net (the data access part of .Net) is already disconnected. Data
is moved back and forth between the client and server (even if they're
running on the same machine), in the form of disconnected datasets.
Datasets can be persisted to XML files.
This is one of the cool features of the .Net platform and is really
worth looking into for your needs.
-nick
On Fri, 22 Apr 2005 01:15:39 +0100, "John" <John@.nospam.infovis.co.uk>
wrote:
>Hi
>We have an access app (both front & back ends are in access) that runs over
>win server networks. There are now more and more users who would like to
>take away a copy of app with them, work offline, and when they come back
>expect the client copy to sync (both ways) with the server copy. Seems like
>a reasonable requirement. The question is; what do I need to do to make thi
s
>happen? Do I need to switch the backend to sql server? Front end to vb or
>something like that? Anything else? How do other people do this?
>Thanks
>Regards
>sql
Friday, March 23, 2012
Offiline synchro
Hi everyone,
I am working on a web site / back end for a food delivery service in the UK. I have designed a web site using ASP and a MS SQL server and am now designing the back end for office use in MS Access. I have linked the SQL tables into access for the app to read directly.
My client has informed me that he wants the back end to function without internet connectivity - so that he can still view existing orders if the net goes down.
I have been pondering the best way to do this and have come up with 2 solutions - either duplicate all the tables locally in access and write an import routine to copy data periodically, or set up a copy of SQL server in the office to synchronise the data independently and then tell the Access prog to read from it if it cannot access the web.
I would prefer the latter option as its neater and requires less programming, but I have never done this before (or know if its even possible). Does anyone have any opinion on how this problem would be best overcome, and if the latter solution is viable then how I would go about it?
All help is much appreciated, thank you for reading.
MarkYes, this is possible and usually it is easy.
Microsoft SQL Replication will definitely do what you want, but the exact deails will depend on which problems you want it to solve for you and which ones you want to solve for yourself. Without knowing more, I can't give you specifics.
I've got some strong opinions about ways that I'd set this up, but those are based on which problems suit my style... My users and I prefer dealing with nusiance grade problems every week or so as opposed to show-stoppers every year or so, and I don't know of any way to set up two different databases (which are both editable) that won't occaisionally have conflicts.
-PatP
I am working on a web site / back end for a food delivery service in the UK. I have designed a web site using ASP and a MS SQL server and am now designing the back end for office use in MS Access. I have linked the SQL tables into access for the app to read directly.
My client has informed me that he wants the back end to function without internet connectivity - so that he can still view existing orders if the net goes down.
I have been pondering the best way to do this and have come up with 2 solutions - either duplicate all the tables locally in access and write an import routine to copy data periodically, or set up a copy of SQL server in the office to synchronise the data independently and then tell the Access prog to read from it if it cannot access the web.
I would prefer the latter option as its neater and requires less programming, but I have never done this before (or know if its even possible). Does anyone have any opinion on how this problem would be best overcome, and if the latter solution is viable then how I would go about it?
All help is much appreciated, thank you for reading.
MarkYes, this is possible and usually it is easy.
Microsoft SQL Replication will definitely do what you want, but the exact deails will depend on which problems you want it to solve for you and which ones you want to solve for yourself. Without knowing more, I can't give you specifics.
I've got some strong opinions about ways that I'd set this up, but those are based on which problems suit my style... My users and I prefer dealing with nusiance grade problems every week or so as opposed to show-stoppers every year or so, and I don't know of any way to set up two different databases (which are both editable) that won't occaisionally have conflicts.
-PatP
Wednesday, March 21, 2012
odd TEXT type field problem
Hi,
There is a db with 200GB, with ~160 GB data in it. Most of the data was a
TEXT type field in a table. That field has been dropped and added back with
default NULL but it appears I still have ~160 GB of data.
How is that possible?
updatestats would help?
The table in question has a two field composite clustered index, but not on
the TEXT type field.
The truth is the whole thing is very fragmented. Defragmenting the clustered
index would place exclusive lock on the table?
Your help would be appreciated,
JanosYou can try running DBCC CLEANTABLE on the table that had the TEXT column.
Look up syntax in BOL.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Janos Horanszky" <kob_uki@.hotmail.com> wrote in message
news:emmBIbZEFHA.3368@.TK2MSFTNGP10.phx.gbl...
> Hi,
> There is a db with 200GB, with ~160 GB data in it. Most of the data was a
> TEXT type field in a table. That field has been dropped and added back
with
> default NULL but it appears I still have ~160 GB of data.
> How is that possible?
> updatestats would help?
> The table in question has a two field composite clustered index, but not
on
> the TEXT type field.
> The truth is the whole thing is very fragmented. Defragmenting the
clustered
> index would place exclusive lock on the table?
> Your help would be appreciated,
> Janos
>|||I appreciate Adam, I will try it on our test environment, I let you know
asap.
Janos
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:eDFFq6dEFHA.1012@.TK2MSFTNGP14.phx.gbl...
> You can try running DBCC CLEANTABLE on the table that had the TEXT column.
> Look up syntax in BOL.
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>
> "Janos Horanszky" <kob_uki@.hotmail.com> wrote in message
> news:emmBIbZEFHA.3368@.TK2MSFTNGP10.phx.gbl...
> with
> on
> clustered
>
There is a db with 200GB, with ~160 GB data in it. Most of the data was a
TEXT type field in a table. That field has been dropped and added back with
default NULL but it appears I still have ~160 GB of data.
How is that possible?
updatestats would help?
The table in question has a two field composite clustered index, but not on
the TEXT type field.
The truth is the whole thing is very fragmented. Defragmenting the clustered
index would place exclusive lock on the table?
Your help would be appreciated,
JanosYou can try running DBCC CLEANTABLE on the table that had the TEXT column.
Look up syntax in BOL.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Janos Horanszky" <kob_uki@.hotmail.com> wrote in message
news:emmBIbZEFHA.3368@.TK2MSFTNGP10.phx.gbl...
> Hi,
> There is a db with 200GB, with ~160 GB data in it. Most of the data was a
> TEXT type field in a table. That field has been dropped and added back
with
> default NULL but it appears I still have ~160 GB of data.
> How is that possible?
> updatestats would help?
> The table in question has a two field composite clustered index, but not
on
> the TEXT type field.
> The truth is the whole thing is very fragmented. Defragmenting the
clustered
> index would place exclusive lock on the table?
> Your help would be appreciated,
> Janos
>|||I appreciate Adam, I will try it on our test environment, I let you know
asap.
Janos
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:eDFFq6dEFHA.1012@.TK2MSFTNGP14.phx.gbl...
> You can try running DBCC CLEANTABLE on the table that had the TEXT column.
> Look up syntax in BOL.
> --
> Adam Machanic
> SQL Server MVP
> http://www.sqljunkies.com/weblog/amachanic
> --
>
> "Janos Horanszky" <kob_uki@.hotmail.com> wrote in message
> news:emmBIbZEFHA.3368@.TK2MSFTNGP10.phx.gbl...
> with
> on
> clustered
>
Odd scheduled job behavior
I've scheduled a job to run on a certain schedule, but the Last Run Status date comes back very oddly, a couple years out of synch, the other jobs scheduled report back just fine.
Anyone seen this behavior?
Edward R Hunter, Data Application Designer
comScore Networks, Inc....haven't seen that one, but you could always check the sysjobhistory table in msdb (if you have the rights) to see what the rundate column has stored.
What version of SQL Server are you on?
Anyone seen this behavior?
Edward R Hunter, Data Application Designer
comScore Networks, Inc....haven't seen that one, but you could always check the sysjobhistory table in msdb (if you have the rights) to see what the rundate column has stored.
What version of SQL Server are you on?
Subscribe to:
Posts (Atom)