Saturday, February 25, 2012

Backup and restore

What's the best method to back up windows 2003 with 50 GB data on to an
external USB hard drive. The external hard drive size is 250 GB. Can we do
FULL back up and differential back up on to the same drive? The server with
RAID configuration has SQL server 2000 on it for now. I will be loading
exchange server on to it in few days. The client is ok with loosing weeks
worth of data (ofcourse RAID is there) .
GHOST ... etc., what type of back up and restore is best in my situation.
The second question is, on the above server the active directory is not set
up. This machine is part of a domain server running on Linux. All users
are authenicated on linux server. Can I install Windows Exchange server
2003 on to it? Any complications or pre reqs to do so.
Thanks in Advance
BVRHi
"Uhway" <vbhadharla@.sbcglobal.net> wrote in message
news:uZ5us4FWDHA.1640@.TK2MSFTNGP10.phx.gbl...
> What's the best method to back up windows 2003 with 50 GB data on to an
> external USB hard drive. The external hard drive size is 250 GB. Can we
do
> FULL back up and differential back up on to the same drive? The server
with
Yes you can , I suggest you get some good backup software like arcserver.
While the Windows backup will work better recovery software is needed.
Yes you can do complete and differential backups on the same drive
> RAID configuration has SQL server 2000 on it for now.
You should backup all databases before the windows backup runs, transaction
logs should be backed up every hour
>I will be loading
> exchange server on to it in few days. The client is ok with loosing weeks
> worth of data (ofcourse RAID is there) .
Can I have this client they seem very easy to please. I hope the client is
OK in losing all perfromance out of the SQL box! SQL and exchanged are both
hogs and shouldn't rn on the same machine. Next you are gong to tell me you
run File/Print sharing and IIS as well!!
> GHOST ... etc., what type of back up and restore is best in my
situation.
Archserver has a very good restore option, from CD or disk
> The second question is, on the above server the active directory is not
set
> up. This machine is part of a domain server running on Linux. All users
> are authenicated on linux server. Can I install Windows Exchange server
> 2003 on to it? Any complications or pre reqs to do so.
I wouldn't have thought SQL Server runs of Linux are you using an emulation
package, if so you would already have perfromance problems :)
> Thanks in Advance
> BVR
Suggestions, Get a big tape drive, while slower than DISK more flexible and
cheaper (TAPES vs DISK) you also get more backup/recover options and at the
end of the day what's the use of backing up if you can't restore.
I hope this helps
regards
Greg O MCSD
http://www.ag-software.com/ags_scribe_index.asp. SQL Scribe Documentation
Builder, the quickest way to document your database
http://www.ag-software.com/ags_SSEPE_index.asp. AGS SQL Server Extended
Property Extended properties manager for SQL 2000
http://www.ag-software.com/IconExtractionProgram.asp. Free icon extraction
program
http://www.ag-software.com. Free programming tools

No comments:

Post a Comment