I just last week did an upgrade to 2005 and encountered the same problem as you are having. i also used paul randals blog which corrected problems related to syscols...

thanks

appreciate it

returned this >> PK__fnRR_1087_645351__26297B3EPRIMARY_KEY_CONSTRAINT

i find that it...

remove entries in sys.syscolpars .......

to add a lil more info the above parent_object_id turned out to be a primary key ....but can't find the table to which it belongs so i can drop and...

compress the backup files see if that works

ok great

thanks alot

Wilfred van Dijk (10/7/2008)

---

A full backup is just a copy of every used page in your database. So if you have some sort of fragmentation in your database, it's there...

So far i understand what you guys are saying. I just want to find out exactly how SQL server restore database from a backup in reference to indexes (Will it...

Thanks Ray,

the above definitely helps

ok thts it. thanks

Ok i got it down to the following error:

Msg 153, Level 15, State 1, Line 6

Invalid usage of the option Weblog20089_Log in the CREATE/ALTER DATABASE statement.

any idea wut this could...

i got the following:

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near 'D:'.

Msg 132, Level 15, State 1, Line 7

The label 'D' has already been declared. Label names...

ok, did that but still getting the same error

ok i just did what u said setting autoclose on, looking at the log i noticed a lot of "starting up database dbname" would this indicate that users or applications...