WWW: http://www.euservices.com
__
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 08, 2004 10:09 PM
To: CF-Talk
Subject: RE: Backup SQL Server Users
> I don't think I was clear in my original post
> I don't think I was clear in my original post. There are a
> lot of databases & users for this SQL Server installation.
> Before the re-install what do I need to do in order to backup
> the users & permissions for all the databases? Do I just
> backup the Master database or maybe if I backup
I agree. We have a variety of otherwise pretty good backup software
available - Retrospect and BrightStor. They seem to do backup okay. It is
only the restore that never seems to work.
We dump everything to a file via a maintenance plan and back that up.
Caveat: If you are doing big league
I don't think I was clear in my original post. There are a lot of databases & users for this SQL Server installation. Before the re-install what do I need to do in order to backup the users & permissions for all the databases? Do I just backup the Master database or maybe if I backup the correct co
> AFAICS the standard tools for SQL Server for doing backups, well, um,
> suck. You might try searching for some evaluation copies of 3rd party
> tools, there was one I used once but I forget its name now.
i think you have that backwards. pretty much most folks on the sql server
list will recomme
AFAICS the standard tools for SQL Server for doing backups, well, um,
suck. You might try searching for some evaluation copies of 3rd party
tools, there was one I used once but I forget its name now.
--
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucomp
Is there an easy way to backup and restore the users for SQL Server 2000? I
will be rebuilding a server soon running SQL Server and I don't want to
manually clean up the orphaned users when I reattached the database, and
then manually add all the users and set permissions. There must be an easy
way
7 matches
Mail list logo