How to easieast way Incremental Backup of SQL Database?

Hi!
We have database which we are continuously updating, and also providing to
our client. And our client also using our database and updating at their
end. We want to give next update as a Incremental only so that our changes
should be given to them and their changes also should be remain there in
their database.
Is there any way to provide Incremental Database?
Thanks
Anil Lakhani
Message posted via http://www.sqlmonster.com
Do you mean data or schema changes ?
If you mean data, then a merge replication solution may work, although you
will need to consider conflict resolution for changes made at the client
that you also make.
If you are talking about schema changes, then you will need to write custom
scripts for this, especially if you are unsure about what changes have been
made at the client site.
Regards,
Rod Colledge.
"Lakhani Anil via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in
message news:232d63e246b74a4eb2065d9bd1f26e9d@.SQLMonster.c om...
> Hi!
> We have database which we are continuously updating, and also providing to
> our client. And our client also using our database and updating at their
> end. We want to give next update as a Incremental only so that our changes
> should be given to them and their changes also should be remain there in
> their database.
> Is there any way to provide Incremental Database?
> Thanks
> Anil Lakhani
> --
> Message posted via http://www.sqlmonster.com

How to easieast way Incremental Backup of SQL Database?

Hi!
We have database which we are continuously updating, and also providing to
our client. And our client also using our database and updating at their
end. We want to give next update as a Incremental only so that our changes
should be given to them and their changes also should be remain there in
their database.
Is there any way to provide Incremental Database?
Thanks
Anil Lakhani
Message posted via http://www.droptable.comDo you mean data or schema changes ?
If you mean data, then a merge replication solution may work, although you
will need to consider conflict resolution for changes made at the client
that you also make.
If you are talking about schema changes, then you will need to write custom
scripts for this, especially if you are unsure about what changes have been
made at the client site.
Regards,
Rod Colledge.
"Lakhani Anil via droptable.com" <forum@.nospam.droptable.com> wrote in
message news:232d63e246b74a4eb2065d9bd1f26e9d@.SQ
droptable.com...
> Hi!
> We have database which we are continuously updating, and also providing to
> our client. And our client also using our database and updating at their
> end. We want to give next update as a Incremental only so that our changes
> should be given to them and their changes also should be remain there in
> their database.
> Is there any way to provide Incremental Database?
> Thanks
> Anil Lakhani
> --
> Message posted via http://www.droptable.com

How to do clustering in SQL Server 2000?

Hi
We Want to do clustering of 2-3 SQL Servers. I m completely new to this
concept. Any pointers around the same are most welcome.
Regards
Priyanka
This is a good place to start:
http://support.microsoft.com/default...b;en-us;888121
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Priyanka" <Priyanka@.discussions.microsoft.com> wrote in message
news:7EA3D9BB-A465-437A-A656-500EB1CBFCA2@.microsoft.com...
Hi
We Want to do clustering of 2-3 SQL Servers. I m completely new to this
concept. Any pointers around the same are most welcome.
Regards
Priyanka
|||Here's a more general view of what Windows Server clusters are for SQL
Server Failover Clustering:
SQL Server 2000 Failover Clustering
http://www.microsoft.com/technet/pro.../failclus.mspx
and Windows Server Clusters:
Clustering Services
http://www.microsoft.com/windowsserv...g/default.mspx
especially the Windows Clustering Architecture White Papers:
Windows Server 2003 Server Cluster Architecture
http://www.microsoft.com/windowsserv...ercluster.mspx
Windows Clustering Technologies: Cluster Service Architecture
http://www.microsoft.com/windows2000...lusterarch.asp
Enjoy.
Sincerely,
Anthony Thomas

"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%231r8HxByFHA.2072@.TK2MSFTNGP14.phx.gbl...
This is a good place to start:
http://support.microsoft.com/default...b;en-us;888121
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Priyanka" <Priyanka@.discussions.microsoft.com> wrote in message
news:7EA3D9BB-A465-437A-A656-500EB1CBFCA2@.microsoft.com...
Hi
We Want to do clustering of 2-3 SQL Servers. I m completely new to this
concept. Any pointers around the same are most welcome.
Regards
Priyanka