Hi Pablo,

Error :

The testlogship database does'nt exist as a principal logshipping server.

The above error say database testlogship does not exist.

You have mentioned this script does not run on production server....

Eddy...

Assuming the Database is in full recovery and T-log backup job running every 30 min.. below steps can be followed while re-indexing..

1. Take a full backup.

2. Disable T-log...

Hi..

Please the the below options...

Rebooting the server once or restart the SQL services.

Try changing the job owner to sa and run the job and change back to original user.

Shree

Hi...

You can try this steps:

Truncate the log file --- and shrink it to minimum size possible.

This is the code...

USE DatabaseName

GO

DBCC SHRINKFILE(<TransactionLogName>, 1)

BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY

DBCC SHRINKFILE(<TransactionLogName>, 1)

GO

Safe...

Hi..

Do you have any database with name maste4IDR?

It's a info message displayed after DBCC command run on your database.

If you get this message regularly check if there is any...

Hi..

1.Check if you are able to login from atleast 1 login with the role assigned to it.

2.Try to create a test login assign the role to it and try to...

Hi,

You can try the 'extractor' software to convert litespeed backup to native.

Shree

Hi

What is the version you are using?

Have you installed sp2?

Please check

SHREE

Two physical instances on one server are to be upgrade to 2008 by inplace upgrade.

Will it upgrade both the instance automatically when upgrade option selected.

Shree

Hi steve..

I am trying to check if the SQL server is running on Comp B from A...

Both the servers are one same domain....

What are my options from Server A??

Shree

Thanks Terry..

Yes it has only 1 MDF file.. no ldf files..

Shree

Hi,

avg_fragmentation_in_percent is the field you need to look for. If it is bet 0-10 you can ignore, if bet 11-30 REORGANIZE if greater then 30% REBUILD index.

check this link :...

Hi,

Do not run the SQL services under local account. Create a seperate account and run the services on that account.

That should solve the problem

Shree

Hi ,

Try this script it works fine on SQL 2005.

It was posted earlier in this forum.

DROP PROC usp_sql_audit

GO

CREATE PROC usp_sql_audit

AS

SET NOCOUNT ON

IF EXISTS (SELECT * FROM tempdb.dbo.sysobjects WHERE name =...