Fortunately, the apps don't have to be super high-performance. I believe simply separating the sequential files, even though there will be some "jumping around," from the random access files, will provide...

Mmmm. Nope, not aware of that. I was under the impression, from Kevin Klein's article and follow-up blog entry that you could put the log files for all DBs for...

Well, I had some "challenges" with DB names being different between the instances. Actually, on the restore, this newbie finally figured out he could rename the DB to the correct...

uh, ummm, well, when I can finally wrest the application away from the main user (who is also the application administrator since that is where the users for the app...

I guess I could, but I wouldn't want to do so right now. It's the old "if it ain't broke, don't fix it" thing.

Problem resolved. Turned out to be another issue. Some how the contents of the entire DB got wiped. In any case, we had a recent backup from which everything was...

Mode is mixed. Not sure what you mean "if users/login are still on the server." No users are logged into that server right now.

Okay, all of the ones that did not migrate are of type System. All the others are there, now. This apparently has some implication as to the migration/copy. Not being...

Yep. Those are the ones. Thanx!

I did this. Just as you said. Sent all the SPs to a file, opened the file in notepad, highlighted every single line, Ctrl-C, opened a QA window in that...

JP,

Many thanks! It sure does!

Rich

I can't thank you enough for your help!!!! It has been extremely valuable! I've been able to move production databases with ease using the import/export model. (I found that easiest...

Trying to restore master by forcing into single mode with sqlservr -c -m at the command line I'm getting some kind of initerrlog error message that there is a OS and...

Actually, maybe you can help me with another issue. I want to direct all logs to another drive reserved just for those logs (and other sequential access type files). I...

That's what I'm going to do!

After accomplishing that, should I then set up replication for the needed databases until the transition is complete? Unfortunately, at least 2 apps aren't going...