Is that doamin account having privileges mentioned under

http://msdn.microsoft.com/en-us/library/ms143504.aspx

MJ

ALTER DATABASE Test1

ADD FILE

(

NAME = Test1dat2,

FILENAME = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\t1dat2.ndf',

SIZE = 5MB,

MAXSIZE = 100MB,

FILEGROWTH = 5MB

)

GO

http://msdn.microsoft.com/en-us/library/aa275464(SQL.80).aspx

MJ

Remove WITH (NOLOCK) and then compare.

MJ

Check the value of awe enabled under sp_configure output.

MJ

Yes, we can as in 2005 this can be controlled by OS and applicable for SQL Server logins if password policy option is checked under login screen.

MJ

Yes, you need to set max server memory when running under dynamic memory configuration.

To check Right Click Server Name under EM-->Memory Tab-->...

MJ

Have this included in your restore statement after restore code

use [cs_DotNetNuke]

EXEC sp_addrolemember N'db_datareader', N'S602561DC4EW31\GPWebUser'

EXEC sp_addrolemember N'db_datawriter', N'S602561DC4EW31\GPWebUser'

HTH!

MJ

This is controlled by OS level setting

http://technet.microsoft.com/en-us/library/cc758659.aspx

MJ

Max server memory should be configured so tht you leave 1-1.5GB of memory for OS. In case there are other applications running on this server then you need to reduce...

Then try creating a new login with same name as this user and associate that login with this user. Once it comes up under security-->users GUI then drop the user...

Can you plz post the output of

USE Databasename

sp_spaceused @updateusage = 'TRUE'

MJ

SQL Server 2005

In SQL Server 2005 the process of implementing Log Shipping is embedded with the Workgroup, Standard and Enterprise editions of SQL Server. To implement it, right click...

Is this resolved?

MJ

Can you post the output of restore filelistonly from disk='complete backupfilepath.bak'?

MJ

Have you checked http://support.microsoft.com/kb/300956

Or

Try installing with domain admin rights if this is not a stand alone instance.

MJ