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: 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: SQL 2005 Failing Backups Because it Exits The Query Prematurely
      ... it might be a behavior change in SQL 2005. ... SQL 2005 Failing Backups Because it Exits The Query Prematurely ... This same application (which uses ODBC) is able to backup SQL 7.0 and SQL ...
      (microsoft.public.sqlserver.odbc)
    • SQL 2005 Failing Backups Because it Exits The Query Prematurely
      ... This same application is able to backup SQL 7.0 and SQL ... The query is not being called asynchronously by the client app. ... I've tried connecting using both the SQL Native Client in ODBC and the SQL ...
      (microsoft.public.sqlserver.odbc)