Here's a more thourough example of using the FileSystemObject (IMO)...

/******************************************************************************

** © Raylev Database Support & Consulting, 2005.

** This script is provided as is, and it's effects are not liable

**for...

Gila Monster, do you use multiple backup files, and if so how many? Or do you seperate backup threads by filegroup backup?

Backup performance is always an interesting topic... ...

Defragging disk on SAN's is really not neccessary due to the way disk/storage is allocated from the SAN to host.

This type of error is either network related or SAN related....

It _should_ complete in around twenty minutes. However, there are far to many variables to take into consideration for a hard number...

Network speed (for either backup copy or network...

Check to see if your account owns a 'duplicate' object..

dbo.Foo

YourAcct.Foo

Yes, you're fine.

A full backup does not mess up the LSN chaining.

If you're going to (or have to) use the 'sa' account, you should know what the password is/was....I don't know if a random sa password process would pass a SOX...

To add...

If you're using a device, the performance of the backup job (not the backup...

Several years ago I wrote a process for this...

1: I used a "master" server that had all of the target servers as Linked Servers.

2: A procedure queried tested...

Nicole (5/12/2008)

---

Thanks a lot guys, I am now able to do it through network. I was giving the path from the address bar from my computer, But now when i...

Why not use a variable as a returncode?

DECLARE @iReturnCode int

EXEC @iReturnCode = EXEC dbo.my_RestoreSP

You'll get either a 0 or an error returned. This is what I do for my...

Rootman (5/12/2008)

---

Not here either.

Although the 'boys and their toys' theory could be right. Many DBA's and other IT people I know ride motorbikes, and even have pictures...

Yes, you can restore it from the network. You'll need to ensure a couple things first though:

1: SQLAgent on the dbserver is using a domain account.

2: The domain account...

Unfortunatly, there isn't anything to do other than find/make the freespace.

If the original database used multiple files, you have the option of restoring them to different physical drives.

The backup file size is relevant only to the amount of data stored, not the amount of storage allocated to the databse.

You can have a 10MB backup file that restores...