|
by: newbiegca_sqlsever2000 |
last post by:
Question 1
3 GHZ CPU (Intel pentium 4) single cpu + 2 GB Memory + SCSI HDD
Database size 10 GB - How long will full database backup take if the
backup is writing a file to the hard disk (separate hard disk)
Question 2
during this full backup are users and application able to access the
|
by: Burt |
last post by:
My company needs to move a 30 Gig SQL Server across the country as soon
as possble on July 1. Turns out moving the full db across the network
takes a few hours.
I'd like to move a full copy of db a week ahead of time, and then just
move either a differential backup(s) or transaction log with with the
week's new data on July 1.
Can anyone suggest the best strategy for doing this? Currently we're
doing a differential backup each hour on...
|
by: Jimmy Chen |
last post by:
Recently I've done a db2 backup and restore/recovery, but the process
for recovering the database was different than what I thought to be.
here is what I did:
DB2 is set in online mode
- backup -
* backup db2 in full
* insert record
|
by: francois1 |
last post by:
I am running a website with a SQL Server database attached.
My transaction logs are full and my hosting co. won't allocate more
disk space for me.
I need to delete my database transaction logs and asume I will need to
run an SQL script to do this.
Problem: I do not have MS Enterprise Manager of any database utility
on my website apart from MS Access. Where can I download a free SQL
tool that I can use to delete the transaction logs...
|
by: sifrah |
last post by:
Hi All,
My SQL server transaction log is getting bigger every day and my HDD if
running out of space.
So i follow the MS KB about how to Shrinking the Transaction Log.
After doing so the log is much much smaller as i can see the size of it
under enterprise manager.
The problem is that the HDD still shows the same size.
If i shrink the DB why the and reduce its size why the HDD does not
|
|
by: danceli |
last post by:
"The log file for database is full. Back up the transaction log for
the database to free up some log space."
Now I only know this way to deal with that manually,
Step1. in option , chance Recovery model from FULL to Simple.
Step2: go to task to manually shrink the log file
Step3: Change recovery model back from simple to FULL.
But by this way, I could get same problem again, the log file is fill,
|
by: m19peters |
last post by:
We have a script that I had to rework a little bit for 2005 that does
a full backup for every database on the server... For some reason on
some nights the script does not backup all databases... Its like it
skips over it for some reason... Output of the script below on the
night in question was:
Executed as user: NT AUTHORITY\SYSTEM. master
(Message 0) Status is ONLINE dbname / dbdevice = master / SQLBUmaster
(Message 0) Processed...
|
by: xeqister |
last post by:
Hi,
I have a DB2 database (version 7) running on Windows 2000 server and
recently facing problem to backup my database. I got an error "Disk
was full" after half way running the backup. My database size is
about 10GB, I have tried to backup the database into a DDS tape (20GB)
or hardisk (100GB free space) but still getting the same error. So,
there is no possibility that the backup media is full. Anyway, here's
part of db2diag.log file...
|
by: Brian D |
last post by:
In MS SQL 2005 when you do a Full Backup does it also backup and
truncate the transaction logs or do I need to back the transaction
logs up separately?
Thanks.
Brian
|
by: rclark30 |
last post by:
Hello to everyone out there. I am a non SQL person TRAPPED in a nightmare!
The long short is we have a CRM 3.0 database that is running in SQL 2005 on a Windows 2003 SP1 Server. (HP ProLiant ML350 3.0ghz 3.5gb RAM)
Server started running out of drive space and could not hold transaction log. Would basically lock up everyones sessions until flushed. Put a cap on log size until drives could be purchased and installed. Perfomance suffered...
|
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: 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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
|