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

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

  • Next message: mal hit: "Migration to Win 2K3" 
    Date: Tue, 4 Oct 2005 07:01:05 -0400

    Now I am not sure what you are referring to. There isn't a way to directly
    generate a backup script that I know of. Can you explain exactly how you
    get to the script? 

    -- 
Andrew J. Kelly  SQL MVP
"Joe" <Joe@discussions.microsoft.com> wrote in message 
news:786D0922-017D-41AE-A915-63F76799F77E@microsoft.com...
> Script backup does not have data?
>
> "Andrew J. Kelly" wrote:
>
>> 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: mal hit: "Migration to Win 2K3"

    Relevant Pages

    • Feedback on backup script
      ... The one problem I have is that the script keeps stopping at lines 633,635 and or 637 with the error "Path Not Found" I have emailed the original author for help but haven't heard back yet. ... I was just wondering if the problem could be that the account running the script doesn't have correct permissions to a share/directory/file that it's trying to backup? ... ' always one less than the actual number of folders. ... ' Show the user free space info on all available disk drives ...
      (microsoft.public.scripting.vbscript)
    • Re: Mirror backup on SQL Server 2005
      ... If you want to overwrite a backup file on disk use WITH INIT instead. ... Andrew J. Kelly SQL MVP ... The remote server I am backing up to does not have SQL Server running it is ...
      (microsoft.public.sqlserver.server)
    • Re: Migration
      ... Andrew J. Kelly SQL MVP ... >>simple example to issue a Full backup of a database to ... >>Andrew J. Kelly SQL MVP ... >>> SQL Server Databases ...
      (microsoft.public.sqlserver.setup)
    • Re: Enterprise Manager Newbie Question
      ... a SQL backup is not a simple copy of the database files. ... Is it possible to write a script that one could run from a workstation and ...
      (microsoft.public.sqlserver.tools)
    • Re: xcopy and vbscript
      ... It takes about 5-6 minutes to backup approximately ... A copy of the script is below for reference. ... ObjShell.Popup strMessage, 5, "Backup Complete", OK_Button ... Dim sSrc, sDest ' as string ...
      (microsoft.public.scripting.vbscript)