amit (9/30/2008)

---

Hi There,

I have run the dbcc updateusage but nothing changed. My question though is that what makes the size of the database so large.

I run a sp_spaceused, the results...

thought it might be. Then you have a fix for the problem and you rest assured your Db is not corrupted. 🙂

did u read my post kotlas7? your first post mentions query analyser and sqlmaint, so this must be SQL2000. Please confirm that.

HAve you checked the maintenance plan options?

Is this in fact a SQL 2000 server? The details of error certainly suggest it is. This sounds exactly like the error you get out of maintenance plan integrity check...

george sibbald (10/1/2008)

---

on the destination server give the source server network admin account rights to the share (serveretwork$). quote]

sorry about the silly typo, that should be domain\servername$

are you running the express instance under local system account, because that cannot perform any functions across the network.

two different things to try

on the destination server give the source server...

sorry barry, my fault, I meant the dataabase design, so many filgroups and files on the same drive.

Perry Whittle (9/30/2008)

---

and don't enable the /3GB switch...

Marios Philippopoulos (9/30/2008)

---

Could it be that not mentioning...

rbarryyoung (9/30/2008)

---

In fact, ask him for a copy of the...

as long as you are using 32 bit SQL server, you will need to enable AWE to access memory over 4GB

thanks Gail. I will be asking him for proof because I don't want this set up going into production.

you ever come across an application database with this many filegroups and...

Todd,

thanks for the quick reply. The article would seem to confirm what I believed, apart from tempdb, multiple files per filegroup give no performance benefit if on the same drive.

So...

backup and restore method with minimum downtime:

backup db

copy over

restore on new server with norecovery

take app down

backup tranlog

copy over

restore tran log with recovery

unless of course your db is very small or...

Maxer (9/23/2008)

---

george sibbald (9/22/2008)

---

are your distmdl files in the same location as your master database files? If they are not this can cause patches to fail.

there have been posts on...