My company is considering purchasing MS SQL Server to run an
application on (SASIxp). I am mainly familiar with Oracle, so I was
wondering how long it would take to copy a database. Basically we have
database A and each night we want to replace database B with the
contents of A. How long would this take say if we had a 10GB database
or a 20GB database.
What would be the technique to do this nightly, the Copy Database
Wizard, Snapshot Replication, Attach & Detach...? We need to automate
this process, and the source database can be made unavailable when
this happens.
Thanks,
Roger 2 10068
<Oa************ **@yahoo.com> wrote in message
news:13******** *************** ***@posting.goo gle.com... My company is considering purchasing MS SQL Server to run an application on (SASIxp). I am mainly familiar with Oracle, so I was wondering how long it would take to copy a database. Basically we have database A and each night we want to replace database B with the contents of A. How long would this take say if we had a 10GB database or a 20GB database.
Well, your maximum speed is limited by hardware. And depending on how you
move things, you may get close to that speed.
What would be the technique to do this nightly, the Copy Database Wizard, Snapshot Replication, Attach & Detach...? We need to automate this process, and the source database can be made unavailable when this happens.
Probably the easiest way given you can suffer from downtime is to do a
detach, copy, attach.
In that case you're pretty much limited to hardware speeds. Thanks, Roger Oa************* *@yahoo.com Kill the 2 trees in email address to reply
(Oa************ **@yahoo.com) writes: My company is considering purchasing MS SQL Server to run an application on (SASIxp). I am mainly familiar with Oracle, so I was wondering how long it would take to copy a database. Basically we have database A and each night we want to replace database B with the contents of A. How long would this take say if we had a 10GB database or a 20GB database.
What would be the technique to do this nightly, the Copy Database Wizard, Snapshot Replication, Attach & Detach...? We need to automate this process, and the source database can be made unavailable when this happens.
An alternative is to use BACKUP/RESTORE. In this case, you can have
the databases available all the time.
How long it would take, depends on the hardware, but for a 10-20 GB, the
process would take something like 15-20 minutes on a decent machine. And
since you probably will backup the database anyway, only the restore
time would be extra.
Yet an alternative to consider is to apply transaction logs. Depending
on the transaction frequency, this can be a lot faster.
--
Erland Sommarskog, SQL Server MVP, so****@algonet. se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: |
last post by:
both of 2 servers are MySQL.
how can I replicate a database to one server from another?
until now I zip the database folder and I extract the zip file in other
MySQL server.
But now I haven't permission to do this in Linux, instead I have admin
permision in MySQL.
|
by: Sarah |
last post by:
Hi!
I have perhaps a strange question... I have a javascript that
activates on a right click and shows the user a little menu of links.
However, by doing so, it disables the users ability to use the Copy
Command when doing a normal right click. I know that in some cases
this would be good for someone who wants to make it harder to copy
pictures from their site... but in this case I WANT people to be able
to copy the pictures....
|
by: pb648174 |
last post by:
I have a very long transaction that runs on the same database that
other users need to use for existing data. I don't care if they see
data from the transaction before it is done and am only using the
transaction because I need a way to roll it back if any errors happen
during the transaction. Unfortunately all tables affected in the long
running transaction are completely locked and nobody else can access
any of the affected tables while...
|
by: db2group88 |
last post by:
we are using db2 udb v8.2 Express edition on windows 2003,we use third
party vendor software to help replicate one server to another.
Production server has three instances, each instances has one database
under it. So we would see three folders on D drive: DB2 folder, TEST
folder and EDU folder, each database has 5 tablespaces and they exist
on F drive. So I told the client to replicate the three instance
folders on D and the data folder...
|
by: Aliza Klein |
last post by:
Hi.
I have a client who has been running my Access 2000 system for a while now
(about a year and a half) and is suddenly encountering lots of problems...
as in misc. fatal errors that shut the database down.
Hard drive space looks good (I think): about 3 GB of about 8 GB free
RAM: 316 MB
O/S: Win XP Home Edition SR-1
Access 2000 service pack 1, I think
| |
by: Jerry |
last post by:
I have an off-the-shelf app that uses an Access database as its
backend. One of the tables contains a field with an "OLE Object"
datatype. I'm writing some reports against this database, and I
believe this field contains data I need. When I view the table in
datasheet view, all I can see in this field is the string "Long
binary data".
So, I've got the problem of needing to extract data from this
field, but I don't know what format...
|
by: rolandsun |
last post by:
we are designing a data collecting system, at each site we have a
database and have a central database,we will write data to site's
database, we want the site-database can publish
the data to central-database Asynchronously, how could we do that?
single replication sounds work,but it will replicate all update
,including delete ,we dont want that,we want only inserted data .
|
by: silvia.fama |
last post by:
Hi!
I'm using c language.
I need to copy a long type value into a char string using a memcpy
function:
memcpy(string, (long *) value, len)
this value will be then insert into a database.
On windows machine it works well, on Solaris not. The windows and
solaris path into c language is the same.
I'd like to say also that real value works correctly also if they are
|
by: ntech |
last post by:
Hello,
i have successfully installed Pgpool-II in linux but i need to know how to replicate databases using it. i dont understand the steps provided in different sites. so, can anyone help me to begin it from the beginning. what are the steps to be followed out to replicate postgres database using pgpool-II. its quite urgent.
Thanks,
ntech
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |