Re: Restoring DB**

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

From: maryam rezvani (rezvani_at_parskhazar.net)
Date: 12/19/04

  • Next message: maryam rezvani: "Re: dif backup**" 
    Date: Sun, 19 Dec 2004 07:57:16 +0300

    I'm restoring my db in wizard mode ,how can I use with move option in this
    case?
    if it's not possible what's the right statement for it?
    Thanks alot
    "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
    news:#UB3gvQ5EHA.3368@TK2MSFTNGP10.phx.gbl...
    > It sounds like the location of where the files were on the original
    machine
    > are different than the one you are restoring to. If that is the cases you
    > must use the WITH MOVE option to specify a new location. If your log file
    > is 6GB and your db is only 450MB you are not doing backups properly. You
    > must issue regular log backups if you are in FULL recovery mode, otherwise
    > set it to SIMPLE. That will keep the log file from growing. These will
    hep
    > you get it back to normal size.
    >
    >
    >
    > http://www.nigelrivett.net/TransactionLogFileGrows_1.html Log File issues
    > http://www.support.microsoft.com/?id=317375 Log File Grows too big
    > http://www.support.microsoft.com/?id=110139 Log file filling up
    > http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File
    > http://www.support.microsoft.com/?id=315512 Considerations for
    Autogrow
    > and AutoShrink
    > http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL
    > Server 7.0 Tran Log
    > http://www.support.microsoft.com/?id=272318 INF: Shrinking Log in SQL
    > Server 2000 with DBCC SHRINKFILE
    > http://www.karaszi.com/SQLServer/info_dont_shrink.asp Shrinking
    > considerations
    >
    >
    > --
    > Andrew J. Kelly SQL MVP
    >
    >
    > "maryam rezvani" <rezvani@parskhazar.net> wrote in message
    > news:ODYGgTM5EHA.2180@TK2MSFTNGP12.phx.gbl...
    > > Hi
    > >
    > > I restore my db backup in different station by following the same steps
    > > .but
    > > in some of
    > > them it restores successfully and in the others folowing error
    appearred.
    > > (my db is in
    > > full recovery model and it's backup size is about 450mg and it's .mdf
    and
    > > .ldf files
    > > are about 450mg and 6gig in order)
    > >
    > > error:
    > > "modify file encountered operationg system error 112 (error not found)
    > > while
    > > attemting
    > > to exapand the physical file. could not create one or more
    files.consider
    > > using the
    > > with move option to modify while location restore database is
    terminating
    > > abnormally."
    > >
    > > I checked the destination if it's correct or not and the enough
    > > space(about
    > > 10gig is
    > > free on destination drive) but still above error happenned.any help
    would
    > > be
    > > greatly
    > > thankful.
    > >
    > >
    > >
    > >
    >
    >

  • Next message: maryam rezvani: "Re: dif backup**"

    Relevant Pages

    • Damaged backup file?
      ... The backup file contains 2 files: data file and a log file. ... Restoring only data file is successful, ...
      (microsoft.public.sqlserver.server)
    • Re: Deleted my log file
      ... Restoring a .mdf ... "Ooops" wrote in message ... > I inadvertently deleted my log file, but still have my data file...is ... there anyway to restore the database from the data file only? ...
      (microsoft.public.sqlserver.server)
    • Log file is getting bigger
      ... DEV.After restoring in DEV i am deliting old ... data.After deliting DEV's log file becomes 30GB.Any idea why log file ... is getting this big after recovery mode is set to Simple? ...
      (comp.databases.ms-sqlserver)