oohhh i dunno, add in a couple of LOB columns and you'd be well away LOL

certainly could do with a little huh hum normalisation 😉

your welcome m8tey 😉

remember to ensure security permissions are retained on the data folders otherwise the SQL server service may not be able to access the files 😉

use SQLCMD not OSQL, check BOL for SQLCMD help

a little bit of de ja vue with this post me thinks 🙂

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