just to re iterate, there is definitely a space after cfg.

copy the line out to a text file and you'll see it

follow the restore gui and in the restore to database type the new database name. select from device and browse for the backup rest is straight forward

or T-SQL

RESTORE DATABASE mine...

my this has gone a little OT hasnt it

you are always best to backup to local disk then copy to the network, unless of course you have a guaranteed solid network connection then maybe

if running under a sql agent job as sql agent (i.e. a user other than the user who created the project) this is well known. How does the sql agent...

quantify this some more! Failed miserably how. I use Redgate SQLBackup commercially over around 10 SQL servers backing up databases, never get a problem!

open the job properties and set the owner to sa

using a product such as Redgate SQLBackup you can compress backups by up to 90%

download the free trial and try it out

to clarify further the only way to truncate log at backup...

not sure exactly what you mean but you'd have to ask your administrator which server hosts mail on your network. Test connectivity by Telnet to port 25

or just launch the sql2005 installer and select the sample databases option from the install selection!

RAID 5 employs striping with parity !!

run the traces server side then you'll have no worries 😉

LOOKUP_BI (10/17/2008)

I need to schedule a sql trace on Profiler.I see a stop time but no start time.Accordin to msdn I can schedule a Trace by the SQL Profiler GUI...

i could be wrong and let me know if i'm way off but it sounds to me like you have moved the database to a new server...