RE: MSDE Backup

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: Strange SQL Server Timeout Problem
    ... I've set the database to use SIMPLE recovery mode. ... huge transaction log associated with the database. ... first suggestion, so I'll check back to see whether the logfile shrinks ...
    (microsoft.public.sqlserver.server)
  • Re: Backup - This sub task is ignored
    ... If it is in simple recovery mode doesent that drop the ... backup will that drop the transaction log too? ... >> Backup can not be performed on database 'ProductionBM'. ...
    (microsoft.public.sqlserver.server)
  • Re: Last Database Transaction Log Time
    ... The database is in full recovery mode. ... still wondering why the old last transaction log backup date. ...
    (microsoft.public.sqlserver.server)
  • Is msdb transactional???
    ... It is true that backup history, jobs, etc are in the MSDB ... but NO "data" is stored in any transaction log. ... It only stores transactions performed upon the database. ... it is usually fine to leave it in Simple recovery mode. ...
    (microsoft.public.sqlserver.server)
  • Re: What is prev1.edb and why is it 15 GB?
    ... > Whereas the database was new and everything was available> to rebuild the database we moved all the database and log> files into a temporary location. ... Had to manually mount the mail store so it> created a new database. ... Only> problem we have is when starting Outlook on the clients> we get a message stating Exchange is currently in> recovery mode. ... The choices are connect, work offline and> cancel. ...
    (microsoft.public.windows.server.sbs)
Loading