Is MSDE for us ?

Tech-Archive recommends: Fix windows errors by optimizing your registry

anonymous_at_discussions.microsoft.com
Date: 04/01/04 

Date: Thu, 1 Apr 2004 11:33:07 -0800

hi,

I use MSDE. What I did for maintenance and backup was
creatin script. It's not that hard. In enterprise
manager, you can plan some jobs and generate scripts
after. then, you copy and paste the sql langage
information for you script. But to do so, you must have,
for example, one backup.bat (wich contains the login info
to the sqlserver --- In my cas, i use the osql command)
and another backup.sql (wich contains backup info).
>-----Original Message-----
>Hi all,
>
>we currently use SQL 7 and have about 50 users, and
never more than 25 concurrent users. The databases
themselves are no bigger than a GB.
>
>I am looking at the expensive exercise of upgrading to
the latest version of SQL Server but was wondering if
MSDE would be fine for us.
>
>Are there any tools that assist in Administering the
databases ? i.e. Backups / Optimize etc ?
>
>Any help here would be greatly appreciated
>.
>

Relevant Pages

  • Re: Backing up Sharepoint?
    ... The MSDE is being backed up by the backup software, ... (irrespective of which SharePoint product and version it is). ... What I would suggest is to simply write a little script for the stsbackup ...
    (microsoft.public.sharepoint.windowsservices)
  • Feedback on backup script
    ... The one problem I have is that the script keeps stopping at lines 633,635 and or 637 with the error "Path Not Found" I have emailed the original author for help but haven't heard back yet. ... I was just wondering if the problem could be that the account running the script doesn't have correct permissions to a share/directory/file that it's trying to backup? ... ' always one less than the actual number of folders. ... ' Show the user free space info on all available disk drives ...
    (microsoft.public.scripting.vbscript)
  • Re: Enterprise Manager Newbie Question
    ... a SQL backup is not a simple copy of the database files. ... Is it possible to write a script that one could run from a workstation and ...
    (microsoft.public.sqlserver.tools)
  • Re: xcopy and vbscript
    ... It takes about 5-6 minutes to backup approximately ... A copy of the script is below for reference. ... ObjShell.Popup strMessage, 5, "Backup Complete", OK_Button ... Dim sSrc, sDest ' as string ...
    (microsoft.public.scripting.vbscript)
  • Re: How do I move an account... A few more details... and more
    ... >> use this system as a backup system if the first ever goes down. ... >> rsync for this. ... >serv1 and the system you back up to is fs. ... >rsync script. ...
    (Fedora)