Re: newbie backup question

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

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 06/30/04 

Date: Wed, 30 Jun 2004 16:40:53 +0200

See the URL's in below article:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Josephine" <anonymous@discussions.microsoft.com> wrote in message
news:2e4701c45eae$38ad52e0$7d02280a@phx.gbl...
> Please help clear up my confusion...
> I have a database that was set in FULL recovery mode and
> the transaction log was not being backed up. To stop the
> log from growing, I switched it to SIMPLE, but after last
> night's backup I still have a 12 GB log file.
> How do I get the transactions to commit to the .mdf file?
> My concern is the data is just there in the log and if I
> back it up it isn't commited to the .mdf file.
> Backup the log file and then continue with the simple
> recovery backups?
> Is there a way to do this in EM?
> If I do this do I want no_truncate, truncate on chk pt?
> Thanks in advance for help,
> Josie.
>

Relevant Pages

  • Re: ldf file missing...
    ... i'm agree with you but the most recent backup is dated nov 2004.... ... the problem now is the recovery of this mdf file and his recent data... ... >> new log file will be created and you can see the db in EM. ... one database mdf file and one log file. ...
    (microsoft.public.sqlserver.server)
  • RE: Error with SBS backup
    ... Error 800423f4 appears in the backup log file when you back up a volume by ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Still dont understand log backups
    ... The transaction log, whether or not it is one or many files, is a serial, ... until the end of the physical log file is reached. ... backup is executed, the active "virtual" logs are backed up, but the ... Using BULK LOGGED, does the online log file contain EVERY transaction for all time -- given that I don't truncate it manually? ...
    (microsoft.public.sqlserver.server)
  • Re: Can anyone crash course me in SQL maintenance?
    ... There is nothing you could do to make SQL Server dump logged transactions before they get committed to the data. ... If you take a nightly full db backup, that would leave you with 24 hours of vulnerability to data loss. ... The log file can be much smaller than the data since it only records the transactions that occur. ... So if someone accidentally deletes important data, you can restore a copy of the database exactly as it was 1 second before that mistake. ...
    (microsoft.public.windows.server.sbs)
  • Re: NTbackup problem
    ... ErrorLevel 87 is generated by ntbackup.exe. ... know what it means but I suspect it's an access problem. ... which backup log is the most recent log file. ... If I check the backup*.log file of the last backup, ...
    (microsoft.public.windowsxp.general)