I faced the login failed for user error while installation and it was because of password for log on account I used to start services was expired.

Check whether the...

Why don't you configure two separate jobs?

Hi All,

My issue is resolved, when my user database completely recovered. 🙂

But still it is confusing why my all SQL Server agent jobs where not run as it was user...

I have scheduled checkdb for the database on weekly basis.

Last run checkdb was run on last sunday and it is not showing me any error.

And I have taken last full...

Thanks Gila for your prompt reply,

I have restored latest backup of live database on UAT.

and it is giving me error on checkdb.

Is their any alternative solution for this.

getting following error on

dbcc checkdb()

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown),

page...

no that dll is not present on

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\SQLDTSSS90.DLL

location

I found that on following location

C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLDTSSS90.DLL

thanks sqlbuddy for your reply.

but it is showing me following out on execution of select statement

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\SQLDTSSS90.DLL

C:\Program Files (x86)\Microsoft SQL Server\100\Shared>mofcomp "C:\Program Files

(x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"

please note that it is absolutely not recommended to shrink the data files as they will create fragmentation in your file and it will reduce the performance

If possible configure ssis package for the same if you want analyze database growth for multiple server.

And if you want to for just one server you can configure job for...

SELECT destination_database_name AS 'Database Name',

restore_date AS 'Date Restored',

CASE restore_type

WHEN 'D' THEN 'Full Backup'

WHEN 'I' THEN 'Diffrential backup'

WHEN 'L' THEN 'Log Backup'

END AS 'Restored From',

CASE recovery

WHEN 1 THEN 'Yes'

WHEN 0 THEN...

1)

USE master

GO

SELECT NAME,STATE_DESC FROM SYS.DATABASES

WHERE STATE_DESC='SUSPECT'

GO

2)

USE master

GO

ALTER DATABASE database_name SET EMERGENCY

GO

3)

DBCC CHECKDB (database_name)

GO

4)

ALTER DATABASE database_name SET SINGLE_USER WITH ROLLBACK IMMEDIATE

5)

DBCC CHECKDB (database_name, REPAIR_ALLOW_DATA_LOSS)

Please check for...

No, You don't need to restart for setting max server memory.

sp_configure 'max server memory (MB)',your_valr

go

reconfigure with override

go

Yes, tried to execute the same using Admin account.