RE: How to copy or restore an entire database(everything) from one ser

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Saleem Hakani (Saleem_at_sqlnt.com)
Date: 09/13/04 

Date: Sun, 12 Sep 2004 22:37:06 -0700

What about snapshot replication.

HTH
Saleem@sqlnt.com

"Leon" wrote:

> I am in a situation where I have to copy an entire database(not only
> data but alos storedprocedures etc like restoring a database) from one
> server to another server from time to time. I could archive by
> creating a backup file from one server, copy that to the another
> server and then restore a database from the backup file. but the thing
> is the backfile is too big to copy it over. Are there any scripts or
> whatever I run to archive this?
>
> Thank a lot in advance,
>

Relevant Pages

  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)
  • Re: sbs2003 and sharepoint
    ... The process described in the link does not refer to restoring to a different server. ... Your first step would be to have a new companyweb on an SBS server and then restore to that the files in from the databases you backed up. ... >> database the other one is the configuration database. ...
    (microsoft.public.windows.server.sbs)
  • Re: TNS could not resolve the connect identifier
    ... This database resides on Machine A. ... The Web server is running on Machine B. ... Using tnsping is not as good as using a real connection such as via ... client (note that this is terminology that appears in the 10g R2 ...
    (comp.databases.oracle.server)