:)
----- Original Message -----
From: Eric Creese
To: CF-Talk
Sent: Wednesday, February 04, 2004 1:53 PM
Subject: RE: Restoring DB I'm screwed!
You can use the MOVE WITH option.
Essentially your back up file should look like this. [filename].BAK.
When I stated to change the name of the directories, what you are going to have to do change the name of the directories the .mdf (data file) and the .ldf(log files are going to exist on the new machine. You may also want to select the force restore option as well.
HTH
E
-----Original Message-----
From: brobborb [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 04, 2004 1:47 PM
To: CF-Talk
Subject: Re: Restoring DB I'm screwed!
Well it's only one file, it has no extension. and right now I have put it in the BACKUP directory in the new machine. and I try to do a restore from a file, but it wont work. it tells me to use some MOVE WITH option, but i've looked all over the place and cant find that option! crazy!
----- Original Message -----
From: Eric Creese
To: CF-Talk
Sent: Wednesday, February 04, 2004 1:39 PM
Subject: RE: Restoring DB I'm screwed!
You may have to change the restore setting for the file. There is an options tab when you restore. You will have to put the directory were you want the files to go on the new machine if the directories are different.
-----Original Message-----
From: brobborb [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 04, 2004 1:30 PM
To: CF-Talk
Subject: OT: Restoring DB I'm screwed!
ok, i did a backup on one of the databases, cos the drive was gonna be formatted. Now, all thoughtall the DB stuff went into the BACKUP folder in the MSSQL directory when u make a backup, so thats the only file i copied. O now I am setting up another SQL station and it's not taking that file! I didnt know I was supposed to copy some mdf file ahhh!!!!
What do I do? is there some way? i looked through this backup file and I see all the tables names and eveyrthing so there must still be a way. please help :-(
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
