473,757 Members | 8,085 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to backup up Win2K and SQL server

Tam

Hi,
I am new to Win2k and SQL server and need to back up everything each night.
I used the supplied NT backup utility to schedule a backup but this missed
some files that were open or in use.
I am more used to Unix/Informix where I could backup everything whether it
was in use or not.

How or what would you recommend I use to do my backups?
Thanks.
Jul 20 '05 #1
2 1979
"Tam" <ta**@scotlegal .com> wrote in message
news:IJ******** ************@wa rds.force9.net. ..

Hi,
I am new to Win2k and SQL server and need to back up everything each night. I used the supplied NT backup utility to schedule a backup but this missed
some files that were open or in use.
I am more used to Unix/Informix where I could backup everything whether it
was in use or not.

How or what would you recommend I use to do my backups?
Thanks.


Tam,

I use Backup Exec 9.0 with the SQL Agent (which is an extra cost option)
very successfully. It allows the option of restoring individual tables which
is useful and quicker if you have large databases but only need to restore a
few damaged / corrupt tables.

The other option is to create a maintenance plan to backup your databases
before you run NT Backup. The backups can then be backed up to tape because
they will not be open files.

Regards, Stephen.
Jul 20 '05 #2
Tam
Stephen wrote:
"Tam" <ta**@scotlegal .com> wrote in message
news:IJ******** ************@wa rds.force9.net. ..

Hi,
I am new to Win2k and SQL server and need to back up everything each

night.
I used the supplied NT backup utility to schedule a backup but this
missed some files that were open or in use.
I am more used to Unix/Informix where I could backup everything whether
it was in use or not.

How or what would you recommend I use to do my backups?
Thanks.


Tam,

I use Backup Exec 9.0 with the SQL Agent (which is an extra cost option)
very successfully. It allows the option of restoring individual tables
which is useful and quicker if you have large databases but only need to
restore a few damaged / corrupt tables.

The other option is to create a maintenance plan to backup your databases
before you run NT Backup. The backups can then be backed up to tape
because they will not be open files.

Regards, Stephen.


Thanks.
Backup Exec was previously on the server before being rebuilt but was not
integrated properly so was taken off.
I will look into this before installing so that we get it right.
--
kno
Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1251
by: Kirk Sumpter | last post by:
All, Working on a single machine (win2k) needing to do backups. Trying Backup Table with the following syntax: BACKUP TABLE tbldealers TO 'c:\mysql\backups' BACKUP TABLE tbldealers TO /mysql/backups I've tried with/without quotes, ticks, nothing except the path. I either get error in syntax, or I do get 1 row in set, but there are no files in
0
2809
by: Ola Ogunneye | last post by:
--=_075912CF.F899D547 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Hello again all, I have created an account in the particular database that I was trying to backup Using PHPMYADMIN and I also created the same user account on the OS side. I still got the same 1064 message afterwards. I am still relatively new to Mysql and my adding user only works when I use
5
16861
by: TThai | last post by:
Hi, Appreciated anyone who can help us with our problem. Our backup job for ROUTT database has been failing for the last 4 days. It was working fine for almost a year now. The only thing happened few days before the problem started is the addition of more memory to the server because we've been getting the low virtual memory error. There are two databases in this server so we have two backup jobs everyday. The other backup job runs...
1
4022
by: Fabius | last post by:
Hello, i'm trying to transfer a DB2 database from a PC to another. Following suggestion that Mr. Jan M. Nelken and Mr. Pierre Saint-Jacques give me on this newsgroup i first made a backup of database, the i transferred the full structure of subdirectories of backup to other PC and tried to Create database from backup copy as explained in DB2 manual. I used the visual interface from command center. I inserted manually the location of backup...
5
4914
by: Al | last post by:
Hi, I'm new to DB2 and have what may be a stupid question: Is it possible to backup a DB2 UDB 7.x database on a Linux server and restore it on a Win2k server (both running the same version of DB2)? Backups on the Linux box seem to be a single file. Backups on the Windows box seem to be a directory structure.
5
2417
by: shenanwei | last post by:
I have a primary server and backup server located in different physical sites. The primary server is live and ship logs to backup site every 5 minutes. The primary server is being full online backed up every sunday locally. Those logs are being applied to backup server every five minutes. For example, Primary site has power outage on tuesday, the last log was shipped was S0001000.LOG. Backup server was brought to live, the first active...
2
3075
by: bbxrider | last post by:
win2k adv server/ iis5.0/vb6.0/ado and/or odbc connections on client machine i have an mdb on win2k adv server machine and want internet read/write to it from both a non-windows, red hat, webserver using asp/vbscript and a win xp/2000 machine with vb6.0/ado with or without odbc set up how do you set up the win2k server machine and/or mdb??? i know enough that some application/service needs to be listening on some port so far i have the...
6
2264
by: alanknipmeyer | last post by:
Hi, I`m in the process of migrating a Access 2002 (Run in 2000 mode) from Windows 98 to Win2K Server. It is a shared resource via a file share on the 98 Server. Client systems are Win98 with the shared drive mounted and the application run via the shared drive. I have tried once before, but came across some file locking issues. I thought i had addressed these file locking issues, but it came apparent I hadn't when data started to get...
1
5070
by: Byron | last post by:
Hi, I have(had) an old Win2k Server server with about 30 web site databases (SQL 2000) that just went under due to hardware problems. Thankfully, I have backups of all the databases plus the MDF and LDF files from the hard drive. I want to move all of these sites and their data to a newer server (Win2003) running SQL2000.
0
9489
marktang
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...
0
9298
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,...
0
10072
Oralloy
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...
0
9906
jinu1996
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...
0
9737
tracyyun
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...
1
7286
isladogs
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...
0
6562
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
3
3399
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2698
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.