none of my registered servers have the green and white arrow only connected servers

Scott Duncan (8/11/2008)

---

Watch out for apps backing up their own databases. They may be useful for places that don't have a DBA to look after things properly but otherwise...

fully review all operations that occur over the weekend before the log backup happens on the monday, something is interrupting your backup chain. Does your index rebuild or maintenance plan...

are both machines on a network?

if so, put the cd into the drive of the machine where installation was successful and share the disk out. The launch setup from the...

you can also run the SQL setup from cd and that can be used to modify installed instances

i would apply some normaliastion to table 2 as suggested first as you'll find yourself ending up with some extra tables which will change the query anyway

i always favour migrating to a clean install rather than upgrade existing instances

have you tried re running the patch? it'll tell if if its already installed, might be worth re applying if you can

am i correct in saying you want to remove the extra filegroup and extra log file?

to remove the filegroup all objects in that filegroup would need to be moved to...

the 64 bit database backend should be transparent to the apps. SQL is SQL.

However check with the vendor that their app supports sql2005 as a database platform

use the SP_Addumpdevice stored proc, syntax is as follows

'type', 'device name', 'drive:\path\file'

type is either disk or tape

device name is the logical name you want to use

drive:\path\file should be self explanatory

which apps in particular?

use this handy script to change object owner to another user for objects ion the database

select 'exec sp_changeobjectowner '''+user_name(Uid)+'.'+name+''','' ''' /*owner to assign to, dbo for example*/

from sysobjects

where user_name(uid) <>...

search this site for some of Brad McGhee's tutorials, they're very helpful

as a side note BOL also recommends to update usages too using

dbcc updateusage

I've already seen a similar problem on a couple of databases i upgraded recently.