RE: MSDE Backup

will running the backup in this manner produce a recoverable version of the
databses. Would I also have to restore the transaction logs in a disaster
scenario and if so how would I back them up.

"Vincent Xu [MSFT]" wrote:

Hi George,

Thanks for posting.

The two secnarios you encounter are both normal.

1. It is not just "copy" the database, so the file size is not fixed.

2. Yes, transaction log can only be backed up in bulk-logged recovery mode
or Full recovery mode.

To understand simple recovery mode, please refer to following article:

<http://msdn2.microsoft.com/en-us/library/ms191164.aspx>

Hope this helps.


Best regards,

Vincent Xu
Microsoft Online Partner Support

======================================================
Get Secure! - www.microsoft.com/security
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================



--------------------
Thread-Topic: MSDE Backup
thread-index: AcbR770ttkEoYR5JQJawFgx3SHKBjA==
X-WBNR-Posting-Host: 209.244.152.162
From: =?Utf-8?B?R2VvcmdlIFNjaG5laWRlcg==?=
<georgedschneider@xxxxxxxxxxxxxx>
References: <292CCC9A-3562-403B-A2CB-1D0679A05929@xxxxxxxxxxxxx>
Subject: RE: MSDE Backup
Date: Wed, 6 Sep 2006 13:05:02 -0700
Lines: 14
Message-ID: <FCE32450-9693-49F2-98C7-2222BA72F41A@xxxxxxxxxxxxx>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.sqlserver.msde
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.msde:23863
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.sqlserver.msde

Also when I run osql -E -n -Q "Backup Log DB1to
disk='c:\gbackup\db1_log.trn'" I get an error stating that backup log is
not
supported while the recovery model is simple. use backup database or
change
the recovery model using alter databse. What is this all about.

"George Schneider" wrote:

I'm trying to backup up my MSDE database called db1. I run the
following
command from a command promt.

osql -E -n -Q "Backup Database db1 to disk='c:\backup\db1.bak'"

The command completed successfuly. I notice that the BAK file is
smaller
than the mdf file. Is this normal?



.

Relevant Pages

  • Re: copying the hidden XP recovery partition
    ... containing a copy of XP Pro and what is called the "Product Recovery ... Not only would you "lost the only copy of the OS" should your HDD "go ... backup system that you would employ on a routine basis; ... I was wondering how you can copy the hidden Recovery disk ...
    (alt.comp.hardware.pc-homebuilt)
  • Re: Sharepoint transaction logs
    ... Perhaps you should just backup your transaction logs, ... > the portal_Site transaction log files do not shrink. ... > Has anybody just kept the portal_Site db recovery option to simple? ...
    (microsoft.public.sharepoint.portalserver)
  • Re: truncate transaction log
    ... backup after the bulk logged operation. ... you said you did a Backup Log with Truncate_Only. ... point in time recovery or even log file recovery then maybe you should ... Make sure when you switch back to Full recovery mode you issue a ...
    (microsoft.public.sqlserver.server)
  • Re: How can I back up a log-shipped database?
    ... This means that a later log backup from the production database will not just be ... able to add the log records to the log-shipped database, because the transaction log has been ... It's clear I don't understand the whole RECOVERY business. ...
    (microsoft.public.sqlserver.server)
  • Re: Task Scheduler service - access is denied
    ... > preparation for doing the recovery from backup, ... Further, my backup software (Stomp's ... >>>Microsoft MVP (Windows Server System: ...
    (microsoft.public.windowsxp.security_admin)
Loading