Hi

Where I need to run this script,Primary server or Secondary

Binu

I am able to connect from the server,other server in the same domain

Problem is from my laptop.

I am able to connect to the default instance from laptop

I am using <IPADDRESS>\Instancename...

SQL Browser is running

TCP IP enabled

Port is dynamic port.

I tested that also

No luck

but I am able to connect to default instance

Windows 2003

verify Only is not working for sql native since it is redgate backup.Not able to see verify option in redgate tool

These drives are clustered drives.I am not sure SQL native can do the verify only option.

"RESTORE DATABASE [XRMWH20] FROM

DISK = 'J:\replication\FULL_SQL4_XRMWH20_20120614_151504_1.sqb',

DISK = 'J:\replication\FULL_SQL4_XRMWH20_20120614_151504_2.sqb',

DISK = 'J:\replication\FULL_SQL4_XRMWH20_20120614_151504_3.sqb',

DISK = 'H:\replication\FULL_SQL4_XRMWH20_20120614_151504_4.sqb',

DISK = 'H:\replication\FULL_SQL4_XRMWH20_20120614_151504_5.sqb',

DISK = 'H:\replication\FULL_SQL4_XRMWH20_20120614_151504_6.sqb',

DISK = 'H:\replication\FULL_SQL4_XRMWH20_20120614_151504_7.sqb',

DISK = 'H:\replication\FULL_SQL4_XRMWH20_20120614_151504_8.sqb',

DISK =...

Hi

Service account is LocalSystem.

I resolved the issue

I added BuiltIN\Administrators on SQL level and given sysadmin privilage.then started sql agent

it started

But one doubt.SQL Server was running without any issue.builtin\admin not...

Exactly I am not sure.But I Saw that last 3-4 months it was not running.I came new to this project(Account)

I have the same error with other databases also

FCB::RemoveAlternateStreamsByHandle(BackupSeek): Operating system error (null) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf'. Diagnose and correct the operating system error,...

I got the error for tempdb while executing a script.Pls advise.

Msg 824, Level 24, State 2, Line 74

SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x55555555;...

Now I found one more thing.

When I checked sys.databases I found that is_cleanly_shutdown column showing value 1

How I can make it to 0 ?

restart of SQL Server will resolve ?

Thanks alot.

One more doubt

I have a table with Clustered Index and 2 Nonclustered Index.If I drop the Clustered Index what will happen for my table and nonclustered index.will my table...

Thanks for your update.I did the same way.

Now I have one doubt.

We have Cumulative Updates and Hotfixes for every SP.How we can Identify these required or not and how can...

Try first to connect through SQL Account(sa)