Exchange and SQL backup on SBS (WinNT)

Hi.
I'm looking for and information how to backup Exchange (configuration and
data), SQL (configuration and data) and user accounts (password, SID,
configuration,...) with native tools on WinNT 4 (ntbackup, copy,...)?
I don't have tape drive. I would like to use an network server to store data
(so backup to stream which I will later redirect) or to a 'disk media'. Is
it posible to use ntbackup for those purposes? If not ... can ntbackup fit
my needs in combination with tape drives?
What about restore of those data in case of disaster (I guess that I have to
reinstall windows, but do I have to do any configuration or will it be done
by the backup)? What about restore a past state of data on a 'running'
system and/or testing backups (I realy don't want to realize that my backup
are unusable when I will need to restore data after the disaster)?
Is there any other 'free' tool to backup those data or is there a simple
procedure to use copy and/or native MS API to do mentioned tasks?
Does anyone know of a free tool like tar, that know how to handle ACLs and
posibly alternate data streams?
Regards,
DezoDamir... first off you posted to about 7 different newsgroups when only
one was needed. SBS. okay... I'm not certain what version of SBS you
have? If you have SBS 2000 and especially now with SBS 2003, the
NTbackup included is very adequate.
Do you have SBS 4.5? or a later version of SBS.
Scheduling Backups in Windows NT 4.0:
http://www.techtutorials.com/tutorials/nt/ntbackup.shtml
I know that the new ntbackup in SBS2003 can back up to a mapped drive
location and thus you can use an external usb harddrive or other
alternative location... I honestly cannot remember if the NTbackup back
in those NT4 days did this [I don't think it does]
SBS2k3 gives way more options and alternatives including volume shadow
copy and is a more robust system. Windows NT and 2000 both have issues
with Short file name issues whereas SBS2k3 is much better at handling
this issue.
Damir Dezeljin wrote:
> Hi.
> I'm looking for and information how to backup Exchange (configuration and
> data), SQL (configuration and data) and user accounts (password, SID,
> configuration,...) with native tools on WinNT 4 (ntbackup, copy,...)?
> I don't have tape drive. I would like to use an network server to store data
> (so backup to stream which I will later redirect) or to a 'disk media'. Is
> it posible to use ntbackup for those purposes? If not ... can ntbackup fit
> my needs in combination with tape drives?
> What about restore of those data in case of disaster (I guess that I have to
> reinstall windows, but do I have to do any configuration or will it be done
> by the backup)? What about restore a past state of data on a 'running'
> system and/or testing backups (I realy don't want to realize that my backup
> are unusable when I will need to restore data after the disaster)?
>
> Is there any other 'free' tool to backup those data or is there a simple
> procedure to use copy and/or native MS API to do mentioned tasks?
>
> Does anyone know of a free tool like tar, that know how to handle ACLs and
> posibly alternate data streams?
>
> Regards,
> Dezo
>
>
--
"Don't lose sight of security. Security is a state of being,
not a state of budget. He with the most firewalls still does
not win. Put down that honeypot and keep up to date on your patches.
Demand better security from vendors and hold them responsible.
Use what you have, and make sure you know how to use it properly
and effectively."
~Rain Forest Puppy
http://www.wiretrip.net/rfp/txt/evolution.txt|||> Damir... first off you posted to about 7 different newsgroups when only
> one was needed. SBS.
Sorry for this. I guess that all the posted groups were somehow colegated
with the question, because I'm not looking for all_in_one tool (so not
necesary ntbackup). I'm realy sorry to spaming you ... I will try to avoid
posting to so many groups in the future.
> Do you have SBS 4.5? or a later version of SBS.
Yes ... I'm using SBS 4.5 running on WinNT 4.0
> SBS2k3 and VSS
I also know that SBS 2003 can do snapshots. This solves a problem with e.g.
open files, but doesn't completly resolve the problem of backups
(application should suport VSS and flush all data to HDD so that the backup
is consistent). For older version of windows there are some other snapshot
tools available (e.g. a good and chip solution is VolumeSnapshot from
StorageCraft).
I'm trying to implement the backup in a company with limited budged so there
is no way to upgrade to SBS 2003. I think that there is no problem for
doing SQL backup (just do some sort of databases lock and than dump all
databases to file(s) ). The major problem is backing up user accounts and
Exchange data. As I know user acounts are stored in the registry and
exchange data are stored in more files. So I don't know if is it posible to
make an 'cold' backup (reboot to an completly diferent OS and only copy some
files to another location - how about restore)?
Regards,
Dezo|||Back in the NT4 and even still the 2k days ... we have a huge issue with
SFN [short file name] issues so that if you do a "bare metal restore"
you will have issues with the OS and will need to stick the SBS cdrom
back in and "refresh" the OS.
There are some backup scripts in these links..
Google Search: ntbackup group:*smallbiz:
http://groups.google.com/groups?q=ntbackup+group:*smallbiz&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=E413AF64BB5ED211A62100A02498E40E08D47E%40pdc-know.knoworries.nl&rnum=2
Google Search: ntbackup group:*smallbiz:
http://groups.google.com/groups?q=ntbackup+group:*smallbiz&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=3bbeb201%240%2422652%24afc38c87%40news.optusnet.com.au&rnum=6
And how to dump out sQL so it can be backed up.
Google Search: ntbackup sql group:*smallbiz:
http://groups.google.com/groups?q=ntbackup+sql+group:*smallbiz&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=Ov4PaWec9GA.215%40uppssnewspub04.moswest.msn.net&rnum=1
You know what I would do? Get a used tape backup from e-b-a-y I don't
think you will be able to back up to non tape locations...
Damir Dezeljin wrote:
>>Damir... first off you posted to about 7 different newsgroups when only
>>one was needed. SBS.
> Sorry for this. I guess that all the posted groups were somehow colegated
> with the question, because I'm not looking for all_in_one tool (so not
> necesary ntbackup). I'm realy sorry to spaming you ... I will try to avoid
> posting to so many groups in the future.
>
>>Do you have SBS 4.5? or a later version of SBS.
> Yes ... I'm using SBS 4.5 running on WinNT 4.0
>
>>SBS2k3 and VSS
> I also know that SBS 2003 can do snapshots. This solves a problem with e.g.
> open files, but doesn't completly resolve the problem of backups
> (application should suport VSS and flush all data to HDD so that the backup
> is consistent). For older version of windows there are some other snapshot
> tools available (e.g. a good and chip solution is VolumeSnapshot from
> StorageCraft).
>
> I'm trying to implement the backup in a company with limited budged so there
> is no way to upgrade to SBS 2003. I think that there is no problem for
> doing SQL backup (just do some sort of databases lock and than dump all
> databases to file(s) ). The major problem is backing up user accounts and
> Exchange data. As I know user acounts are stored in the registry and
> exchange data are stored in more files. So I don't know if is it posible to
> make an 'cold' backup (reboot to an completly diferent OS and only copy some
> files to another location - how about restore)?
>
> Regards,
> Dezo
>
--
"Don't lose sight of security. Security is a state of being,
not a state of budget. He with the most firewalls still does
not win. Put down that honeypot and keep up to date on your patches.
Demand better security from vendors and hold them responsible.
Use what you have, and make sure you know how to use it properly
and effectively."
~Rain Forest Puppy
http://www.wiretrip.net/rfp/txt/evolution.txt|||In news:eNx$HjJkDHA.2140@.TK2MSFTNGP09.phx.gbl,
Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP] <sbradcpa@.pacbell.net> wrote:
> Back in the NT4 and even still the 2k days ... we have a huge issue
> with SFN [short file name] issues so that if you do a "bare metal
> restore" you will have issues with the OS and will need to stick the
> SBS cdrom back in and "refresh" the OS.
I did a restore of my server (SBS 2003) as a test. The server has several
non MS tools installed including ISA server. I deleted my Raid 5 array,
created a new one, booted from the first CD, did a full directory restore
including all files, folders and drives. The server was up and running in
about 1 hour.
No issues with SFN at all.
--
Mariette Knap
http://wwww.smallbizserver.net|||When I said the 2k days ...that's SBS 2000. As Jeff has posted... [and
I'm forgetting his write up as it's now off this newsserver] but the
issues are resolved in 2k3
Mariette Knap [SBS MVP] wrote:
> In news:eNx$HjJkDHA.2140@.TK2MSFTNGP09.phx.gbl,
> Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP] <sbradcpa@.pacbell.net> wrote:
>
>>Back in the NT4 and even still the 2k days ... we have a huge issue
>>with SFN [short file name] issues so that if you do a "bare metal
>>restore" you will have issues with the OS and will need to stick the
>>SBS cdrom back in and "refresh" the OS.
>
> I did a restore of my server (SBS 2003) as a test. The server has several
> non MS tools installed including ISA server. I deleted my Raid 5 array,
> created a new one, booted from the first CD, did a full directory restore
> including all files, folders and drives. The server was up and running in
> about 1 hour.
> No issues with SFN at all.
>
--
"Don't lose sight of security. Security is a state of being,
not a state of budget. He with the most firewalls still does
not win. Put down that honeypot and keep up to date on your patches.
Demand better security from vendors and hold them responsible.
Use what you have, and make sure you know how to use it properly
and effectively."
~Rain Forest Puppy
http://www.wiretrip.net/rfp/txt/evolution.txt|||You can backup Exchange from any W2K machine on your network.
XADM: Files Needed to Perform Exchange NT Backup on Workstation
PSS ID Number: 181445
Damir Dezeljin wrote:
> > Damir... first off you posted to about 7 different newsgroups when only
> > one was needed. SBS.
> Sorry for this. I guess that all the posted groups were somehow colegated
> with the question, because I'm not looking for all_in_one tool (so not
> necesary ntbackup). I'm realy sorry to spaming you ... I will try to avoid
> posting to so many groups in the future.
> > Do you have SBS 4.5? or a later version of SBS.
> Yes ... I'm using SBS 4.5 running on WinNT 4.0
> > SBS2k3 and VSS
> I also know that SBS 2003 can do snapshots. This solves a problem with e.g.
> open files, but doesn't completly resolve the problem of backups
> (application should suport VSS and flush all data to HDD so that the backup
> is consistent). For older version of windows there are some other snapshot
> tools available (e.g. a good and chip solution is VolumeSnapshot from
> StorageCraft).
> I'm trying to implement the backup in a company with limited budged so there
> is no way to upgrade to SBS 2003. I think that there is no problem for
> doing SQL backup (just do some sort of databases lock and than dump all
> databases to file(s) ). The major problem is backing up user accounts and
> Exchange data. As I know user acounts are stored in the registry and
> exchange data are stored in more files. So I don't know if is it posible to
> make an 'cold' backup (reboot to an completly diferent OS and only copy some
> files to another location - how about restore)?
> Regards,
> Dezo
--
Corrections are welcome.
Please keep all discussions in NG, so that everybody can participate.
Kirill

Excessive paging after enabling AWE in SQL server - memgraph1.jpg (0/1)

After enabling AWE in SQL I am noticing a good bit more paging than
before. The attached jpg file is a graph of memory usage.
The configuration for this server is:
IBM x360 w/ 4 x 1.6ghz processors, 8GB memory
Storage: C: and D: partitions internal drives
Data stored on SAN volumes: 5 x 683GB volumes
# databases on this server: 162
boot.ini file has the /3GB and /PAE switches
OS sees all 8GB of memory.
SQL Server has AWE enabled with memory settings:
Min: 0 Max: 5500
As soon as I enabled AWE in SQL, I noticed the following:
(see jpg of the memory usage graph)
1. MemPhysUsage jumps up to almost 80%
(this is the 5500 mark) (in green)
2. PageFileUsage starts climbing up over time. (in pink)
There was little or no page file usage prior to enabling AWE.
Any ideas?
Thanks in advance
jtw
--
http://www.UsenetRocket.comHi,
if the server is only a MS SQL 2k Server, change the
Server properties - dynamicly configure SQL Server Memory -
Give the Server the maximum of memory.
J.K
>--Original Message--
>After enabling AWE in SQL I am noticing a good bit more
paging than
>before. The attached jpg file is a graph of memory usage.
>The configuration for this server is:
>IBM x360 w/ 4 x 1.6ghz processors, 8GB memory
>Storage: C: and D: partitions internal drives
>Data stored on SAN volumes: 5 x 683GB volumes
># databases on this server: 162
>boot.ini file has the /3GB and /PAE switches
>OS sees all 8GB of memory.
>SQL Server has AWE enabled with memory settings:
> Min: 0 Max: 5500
>As soon as I enabled AWE in SQL, I noticed the following:
>(see jpg of the memory usage graph)
>1. MemPhysUsage jumps up to almost 80%
> (this is the 5500 mark) (in green)
>2. PageFileUsage starts climbing up over time. (in pink)
>There was little or no page file usage prior to enabling
AWE.
>Any ideas?
>
>Thanks in advance
>jtw
>--
>http://www.UsenetRocket.com
>.
>

EXCEPTION_ACCESS_VIOLATION when installing June CTP

Hi - I'm trying to install June CTP on Win2k3 SP1.
Setup failed when trying to start services for configuration.
In log files I found the following
Computer type is AT/AT COMPATIBLE.
Bios Version is INSYDE - 1
Insyde Software MobilePRO BIOS Version 4.00.01
Current time is 11:26:54 08/30/05.
1 Intel x86 level 15, 3 Mhz processor (s).
Windows NT 5.2 Build 3790 CSD Service Pack 1.

Memory
MemoryLoad = 57%
Total Physical = 959 MB
Available Physical = 408 MB
Total Page File = 2329 MB
Available Page File = 1812 MB
Total Virtual = 2047 MB
Available Virtual = 1014 MB
***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\log\SQLDump0001.txt
SqlDumpExceptionHandler: Process 5180 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server i
s terminating this process.
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 08/30/05 11:26:54 spid 0
*
*
* Exception Address = 77BD8944 (strncmp + 00000014)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00330072
*
* MODULE BASE END SIZE
* sqlservr 00400000 01DDEFFF 019df000
* Invalid Address 7C800000 7C8BFFFF 000c0000
* kernel32 77E40000 77F41FFF 00102000
* ADVAPI32 77F50000 77FEBFFF 0009c000
* RPCRT4 77C50000 77CEEFFF 0009f000
* CRYPT32 761B0000 76242FFF 00093000
* MSASN1 76190000 761A1FFF 00012000
* msvcrt 77BA0000 77BF9FFF 0005a000
* USER32 77380000 77411FFF 00092000
* GDI32 77C00000 77C47FFF 00048000
* MSVCP80 7C420000 7C4A4FFF 00085000
* MSVCR80 7C370000 7C408FFF 00099000
* MSWSOCK 71B20000 71B60FFF 00041000
* WS2_32 71C00000 71C16FFF 00017000
* WS2HELP 71BF0000 71BF7FFF 00008000
* NETAPI32 71C40000 71C97FFF 00058000
* opends60 41060000 41065FFF 00006000
* Secur32 76F50000 76F62FFF 00013000
* SHLWAPI 77DA0000 77DF1FFF 00052000
* USERENV 76920000 769E3FFF 000c4000
* psapi 76B70000 76B7AFFF 0000b000
* instapi 02310000 02318FFF 00009000
* sqlevn70 41070000 411ECFFF 0017d000
* SQLOS 02350000 02354FFF 00005000
* rsaenh 68000000 6802EFFF 0002f000
* AUTHZ 76C40000 76C53FFF 00014000
* MSCOREE 78800000 7883FFFF 00040000
* ole32 77670000 777A3FFF 00134000
* msv1_0 76C90000 76CB6FFF 00027000
* iphlpapi 76CF0000 76D09FFF 0001a000
* kerberos 71CA0000 71CF7FFF 00058000
* cryptdll 766E0000 766EBFFF 0000c000
* schannel 76750000 76776FFF 00027000
* security 71F60000 71F63FFF 00004000
* VERSION 77B90000 77B97FFF 00008000
* dssenh 68100000 68123FFF 00024000
* hnetcfg 5F270000 5F2C8FFF 00059000
* wshtcpip 71AE0000 71AE7FFF 00008000
* DNSAPI 76ED0000 76EF8FFF 00029000
* winrnr 76F70000 76F76FFF 00007000
* WLDAP32 76F10000 76F3DFFF 0002e000
* rasadhlp 76F80000 76F84FFF 00005000
* ntdsapi 766F0000 76704FFF 00015000
* dbghelp 3FA40000 3FB49FFF 0010a000
*
* Edi: 00330072:
* Esi: 00330072:
* Eax: 00000000:
* Ebx: 00000008:
* Ecx: 00000008:
* Edx: 01020001: EC83EC8B 78816608 53008002 820F5756 000000A3 8510508D
* Eip: 77BD8944: D9F7AEF2 FE8BCB03 F30C758B FF468AA6 473AC933 740577FF
* Ebp: 3F6EF3A8: 3F6EF3E4 766F4FF6 00330072 766F4F84 00000008 0194A7FC
* SegCs: 0000001B:
* EFlags: 00010246: 00730075 00650074 005C0072 006C0063 00730075 00650074
* Esp: 3F6EF39C: 3F6EF410 77BD8930 766F4F84 3F6EF3E4 766F4FF6 00330072
* SegSs: 00000023:
* *******************************************************************************
* -
* Short Stack Dump
Any help will be appreciated.The AV is happening in the SQL Server engine. I've moved your post to the SQL DB Engine forum. Maybe someone here can help you.

Dan|||Alexandr,

Are you still getting this error? Can you start the service manually?

From the fragment of the output you have provided there is no way to tell what is wrong.

We either need a full dump file (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\log\SQLDump0001.txt) or paste Short Stack Dump.

Regards,
Boris.|||Thanks for reply Boris.
I have reinstalled SQL Server on a brand new OS and it works fine now.

With the previous installation - i cannot start service manually - it gives the same error. I've tried to install SQL Express - and it gives the same error again.
I tried to start SQL Server even not as a service but as a console app - and it gives that error.
That may be happend because I already has installed SQL 2000 and MSDE on my PC.

Regards,
Alexandr.|||Alexandr,

An instance of SQL Server 2005 should coexist just fine with SQL Server 2000. I don't think that is the reason for the AV you were getting, although this is just a guess.

Since you have reinstalled the OS, I wonder if you have kept the dump file(s) that were created when the server generated the AV.

If yes, could you paste short stack dump here and we can take a further look.

Thank you,
Boris.|||Boris,

SQLServer 2005 works fine with SQL 2000 installed on the same box.
I haven't kept the stack dump or log files.

Thanks,
Alexandr.