RE: MSDE Backup

Hi George,

Thanks for your reply.

If you perform full backup regularly, you can just restore the latest
backup when disaster occurs.

The transaction log is a serial record of all the transactions that have
been performed against the database since the transaction log was last
backed up. With transaction log backups, you can recover the database to a
specific point in time (for example, prior to entering unwanted data), or
to the point of failure. Check following article:

<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/a
d_bkprst_565v.asp>

How to: Create a Transaction Log Backup (Transact-SQL)
<http://msdn2.microsoft.com/en-us/library/ms191284.aspx>

How to: Restore to the Point of Failure (Transact-SQL)
<http://msdn2.microsoft.com/en-us/library/ms175093.aspx>

How to: Restore to a Point in Time (Transact-SQL)
<http://msdn2.microsoft.com/en-us/library/ms179451.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: AcbSfNWAJnvm5GkIQvK0wHCuX55O/A==
X-WBNR-Posting-Host: 209.244.152.162
From: =?Utf-8?B?R2VvcmdlIFNjaG5laWRlcg==?=
<georgedschneider@xxxxxxxxxxxxxx>
References: <292CCC9A-3562-403B-A2CB-1D0679A05929@xxxxxxxxxxxxx>
<FCE32450-9693-49F2-98C7-2222BA72F41A@xxxxxxxxxxxxx>
<shd1e2h0GHA.4532@xxxxxxxxxxxxxxxxxxxxx>
Subject: RE: MSDE Backup
Date: Thu, 7 Sep 2006 05:55:02 -0700
Lines: 88
Message-ID: <F97FE4D3-2927-457A-995B-AAC3B7CC90F9@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:23865
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.sqlserver.msde

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: 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: newbie backup question
    ... Your data will be moved to MDF file after the checkpoint, ... You can run the below command to truncate the transaction log, ... Even if you backup the transaction log, ... not be useful since you turned the recovery to SIMPLE. ...
    (microsoft.public.sqlserver.setup)
  • Re: POINT IN TIME RESTORE
    ... Perform a transaction log backup of the original database (If you have ... Restore the subsequent transaction log files in order of backup WITH ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2005 Shrink issue
    ... When you perform a Transaction Log Backup, passive virtual logs in your transaction log file are deleted. ... you can change your database's recovery model to SIMPLE when you want to get rid of your passive virtual logs in your transaction log file. ...
    (microsoft.public.sqlserver.tools)
  • Re: Restoring from non-truncated transaction log
    ... The transaction log is there to support transactional consistency as well ... as supporting "incremental" backup. ... A database backup contains both data pages as well as the necessary log records (from the ... When your restore a database backup, ...
    (microsoft.public.sqlserver.server)
Loading