did you try just kicking off another restore, I would expect that to work.

Rajesh kasturi (2/3/2009)

---

george sibbald (2/3/2009)

---

As soon as you get the 20 .ldfs attached, drop 19 of them. Only reason you would want more than 1 log file is if you...

n.pratheep (2/3/2009)

---

Hi friends,

One of my database datafile, autogrowth option set like 1MB growth and unrestricted, for log file it was 10% autogrowth. I think it is default settting.? Can...

As soon as you get the 20 .ldfs attached, drop 19 of them. Only reason you would want more than 1 log file is if you were totally out of...

if this is a one off process sounds like you want a one off job rather than make it part of the maintenance plan,

If i understand your requirements properly you...

I note that although this is a user database the logical file names are the same as for the system database master. Was this database created by restoring the master...

the MOM onepoint database is in simple mode by default. change the recovery mode to full or bulk-logged and you will be fine.

I logship my onepoint database no problem.

does arcserve backup direct to tape or virtual tape.?

Its common practice to use SQL native backups to disk and then use a tool such as arcserve to copy the .bak...

try and avoid having to move the system db files by placing them where you want them as part of the install process.

Moving master and resource database can cause...

the min requirement for sql 2000...

doesnt sound like an error from a sql restore job. pls post the backup and restore commands you are using, and the results of

restore filelistonly from disk = 'path to...

Well, unless you only want to copy a subset of the database, I would not use the copy wizard. Use detach -copy-attach or backup-copy-restore.

you can change the installation location of the system db files (and program files) by going into advanced options during the install and expanding the database engine tree structure.

I would...

EdVassie (1/25/2007)

---

You have hit the 2 CD problem.

The SQL 2005 install media are divided into 2 CDs. CD 1 contains the server components, and CD 2 contains the client components....

congrats, steve et al, and a worthwhile choice of celebration.