Re: sql servers part of workgroup

From: Greg Obleshchuk (greg-n-o-s-p-a-m-_at_ag-s-o-f-t-w-a-r-e.com)
Date: 04/26/04 

Date: Mon, 26 Apr 2004 16:26:59 +1000

Hi Jason,
I don't think automatic log shipping is possible without a domain. You
might have to write your own log shipping module .
As for backups to network drives then make sure the network share has
everyone and guest as full rights for the directory.

I have some scripts that may help with the manual log shipping
http://www.sql-scripts.com/Members/ScriptDetails.aspx?S_ID=4 

-- 
I hope this helps
--------------------------------
Greg O
Looking for SQL Scripts, Need Help? http://www.SQL-Scripts.com
Document all your databases now.
http://www.ag-software.com/ags_scribe_index.aspx
Crosstab queries from SQL Server.
http://www.ag-software.com/xp_ags_crosstab.aspx
Edit Extended Properties as easy as can be.
http://www.ag-software.com/ags_SSEPE_index.aspx
"Jason" <anonymous@discussions.microsoft.com> wrote in message
news:3c0101c42a17$3cb5ac50$a101280a@phx.gbl...
> I have a client that has a couple of SQL Servers that are
> part of a workgroup. They do not intend to use a domain
> controller...
>
> Now they want to do some activity such as log shipping,
> network backups, etc.. that may require communication
> between the SQL Servers.. I know things are a lot simpler
> if all the SQL Servers had the same domain account that
> has enough priviliges but without a domain controller,
> how can i establish the same ?
>
> Thanks

Relevant Pages

  • RE: Log Shipping
    ... Can you setup log shipping from 5:00 AM to 11:00 PM and then do your full ... backups and any maintenace between 12:00 AM and 3:30 AM. ... >> fine during the initial setup however, the monitor server says under Log ...
    (microsoft.public.sqlserver.replication)
  • List SQL servers in a network
    ... Most of the solutions use SQLDMO to list all sql servers in the network like ... public static string[] GetAvailableSQLServers ... - this does not work with Windows XP (see SQLDMO documentation: ...
    (microsoft.public.dotnet.general)
  • Re: Log Shipping and Backup Jobs = Conflict?
    ... As long as the ONLY log backups are done through log shipping you should be ... I support the Professional Association of SQL Server and it's community of SQL Server professionals. ... > Many thanks in advance for the help, Rgds, Simon. ...
    (microsoft.public.sqlserver.server)
  • Re: daily backup and log shipping
    ... I intend to setup and sync the servers on main office and ship after that, the warm standby db to remote site. ... My question is how the daily full backups of database will afect my log shipping. ...
    (microsoft.public.sqlserver.replication)
  • daily backup and log shipping
    ... I am in the process of setting up log shipping for a large database ~ 1GB over VPN and slow WAN link. ... I intend to setup and sync the servers on main office and ship after that, the warm standby db to remote site. ... My question is how the daily full backups of database will afect my log shipping. ...
    (microsoft.public.sqlserver.replication)
Loading