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

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?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?
>|||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...
>
>|||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...[vbcol=seagreen]
> Script backup does not have data?
> "Andrew J. Kelly" wrote:
>

file ldf too BIG

Hi all!
I would like to reduce the size of MyDataBase_Log.ldf
I use Sql Server 2000.
If it was possible which procedure i have to follow?
Thanks
FractalBlueDo you have any maintenence going on?

You need to Dump the log and truncate at checkpoint

Then lookup DBCC SHRINKFILE

in BOL