SQL Server network backups
From: kjpierick_psa (kjpierick_psa_at_hotmail.com)
Date: 05/24/04
- Next message: kjpierick_psa: "SQL Server 7 shrink transaction logs"
- Previous message: bb_43_at_hotmail.com: "Re: ActiveX tasks won't run in DTS - HELP!"
- Messages sorted by: [ date ] [ thread ]
Date: 24 May 2004 10:53:13 -0700
Hi - I'm new to SQL Server administration, so I'm learning as I go.
I have SQL Server 7.0 and I need to backup the databases and
transaction log files to a different server on our network.
1) Can this be done if the 2 computers do not belong to a domain? If
they are in the same workgroup, is this ok? What will happen if they
are in different work groups?
currentley my 2 servers are in different workgroups, but I'm able
to map a drive from one to the other.
2) I tried to do a SQL backup to from my current server to the other
server, but get an error trying to access the "SHARE".
My MSSQLSERVER is using the "LOCALSYSTEM" userid, so this is probably
the reason I'm getting the access violation to the "SHARE". What do I
need to set this service userid to? what "credientials" does the
account need? How do I setup this account? Does this account need to
be setup on both servers?
3) On the server that I want to do the backups to, does this need to
be running SQL Server? I just want a place to "hold" my backups in my
"production" server fails.
Any help would be greatly appreciated.
- Next message: kjpierick_psa: "SQL Server 7 shrink transaction logs"
- Previous message: bb_43_at_hotmail.com: "Re: ActiveX tasks won't run in DTS - HELP!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
