<div>
Maybe this is something you could find useful?<br />
<a href="http://msdn.microsoft.com/en-us/library/ms189047.aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/ms189047.aspx</a><br />

</div>


Maybe this is something you could find useful?
http://msdn.microsoft.com/en-us/library/ms189047.aspx [http://msdn.microsoft.com/en-us/library/ms189047.aspx]


<div>
It's need to be down time to do this task.<br />
or you can use the reflection or database mirroring.<br />
&nbsp;
</div>


It's need to be down time to do this task.
or you can use the reflection or database mirroring.
 

<div>
<div class="content wysiwyg-content">
Situation. &nbsp;I have two servers. &nbsp;A production and a backup. &nbsp;I want to make sure the production server is backing its MSQL database to the backup. &nbsp;Is there a way to update the backup database rather then a full backup? &nbsp;The idea is all I would have to do is change the IP of the backup server.
</div>
</div>


Situation.  I have two servers.  A production and a backup.  I want to make sure the production server is backing its MSQL database to the backup.  Is there a way to update the backup database rather then a full backup?  The idea is all I would have to do is change the IP of the backup server.

MSQL - How can I keep a backup database up to date.

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.