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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe - 03 Oct 2005 12:20 GMT

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?

Reply to this Message

Andrew J. Kelly - 03 Oct 2005 16:15 GMT

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.

Signature

Andrew J. Kelly SQL MVP

> Dear all,
> I have a question about the difference between file/filegroup backup and
[quoted text clipped - 5 lines]
> 2.) if i backup with sql script backup (select all object), is it the same
> output with full backup?

Reply to this Message

Joe - 04 Oct 2005 07:08 GMT

Script backup does not have data?

> 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
[quoted text clipped - 12 lines]
> > 2.) if i backup with sql script backup (select all object), is it the same
> > output with full backup?

Reply to this Message

Andrew J. Kelly - 04 Oct 2005 12:01 GMT

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?

Signature

Andrew J. Kelly SQL MVP

> Script backup does not have data?
>
[quoted text clipped - 18 lines]
>> > same
>> > output with full backup?

Reply to this Message