Also, in adding file you have added a database file, you should have coded

Alter Database mydb

add LOG file

(input parms)

when you get your database back remove this erroneous file

by

dbcc shrinkfile(mydb_log_1,emptyfile)

then actually...

You can have more than one log file though unless you really do not have the drive space to accommodate the log there is no advantage to having more than...

have to agree with jg, this is not a good file to use with bcp. format file may be the way to go, worth trying. Outside of a format file...

...or comma as the field delimiter but that means the ¬ will appear in the columns which will cause problems for the int data types. you need to strip out...

Michael Valentine Jones (10/13/2009)

---

When you restore a backup from another server, the info about the backup you restored from is stored in the same tables where info about local backups...

you would have to refer back to the prod server, so a linked server would be required.

Presuming you know the full path to the backup file you could use this...

If you attached the database it MUST have bought object level permissions across, and the use of sp_help_revlogin will have tied the users to the logins. Are you talking about...

new line is the default for the row delimiter, so just remove the -r argument.

As you appear to have a header in the file, tell BCP to start loading from...

see url

http://technet.microsoft.com/en-us/library/ms170363(SQL.90).aspx

has anything else taken the single connection before the restore?. test by trying to connect via SQLcmd

don't see why you have specified the -q argument.

what are you trying to define for your row delimiter (-r)?

makes 'em less bouncy 🙂

great, RS is a confusing litttle ******

Jake Shelton (10/8/2009)

---

Hi Jack,

Yes, at your suggestion I've taken the defaults for the Virtual Directory settings - have to say the process to get to them was a tad unintuitive...

haven't heard so don't know if you need or want it but anyway here is a script of post upgrade tasks to perform on a database