Re: file/filegroup backup vs copy the mdf, ndf, ldf file directly

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 10/03/05

  • Next message: Mike Epprecht \(SQL MVP\): "Re: cannot create a simple table" 
    Date: Mon, 3 Oct 2005 11:15:32 -0400

    1.) The only way to safely copy the files directly is to detach the
    database first. That means you must take it off line. A backup does not
    require you to take the db offline.

    2.) The generate script is simply the DDL to recreate the database and
    does not contain the data. It is not to be used in place of a backup. 

    -- 
Andrew J. Kelly  SQL MVP
"Joe" <Joe@discussions.microsoft.com> wrote in message 
news:299DA939-7562-4546-B4A1-15F7CA2D8881@microsoft.com...
> Dear all,
> I have a question about the difference between file/filegroup backup and
> copy the mdf, ndf, ldf file directly
> 1.) If i copy the mdf,ndf,ldf file and then replace the file(recreate the 
> db
> with the same name)  to the sql server, will it works and ok, what is the
> difference with backup file/filegroup backup?
> 2.) if i backup with sql script backup (select all object), is it the same
> output with full backup?
>
  • Next message: Mike Epprecht \(SQL MVP\): "Re: cannot create a simple table"

    Relevant Pages

    • RE: Unable to Shrink Files
      ... Veritas Backup Exec. ... >Shrinking a log is dependent on first truncating the ... log - are you backing it up? ...
      (microsoft.public.sqlserver.replication)
    • RE: Unable to backup a log
      ... When you change the recovery model from simple to full, you need to backup ... the entire database first before you attempt to backup the log ... "Richard Brown" wrote: ... > restore to a point in time. ...
      (microsoft.public.sqlserver.server)
    • RE: Update query syntax
      ... Backup your database first. ... KARL DEWEY ... "Golfinray" wrote: ...
      (microsoft.public.access.queries)
    • Re: Backup erros
      ... You may have a SQL ... Error 800423f4 appears in the backup log file when you back up a volume by ... > Reason: The process cannot access the file because it is being used by> another process. ...
      (microsoft.public.windows.server.sbs)
    • Re: SBS2003, NTBackup-Fehler
      ... Windows Server 2003 to resolve some VSS snapshot issues ... Backup fails on a computer that is running Small Business Server 2003 ... Die Sicherung kann nicht fortgesetzt werden. ... Microsoft OLE DB Provider for SQL Server ...
      (microsoft.public.de.german.backoffice.smallbiz)