Hi,

Its interesting!!! I have created "backup" folder in the path D:\Microsoft SQL Server\MSSQL.1\MSSQL and after that I'm not getting the restore error in the error log !!!

Is this a bug??

Here is my Restore Script:

RESTORE DATABASE MyDB

FROM DISK='D:\Backups\MyDB.bak'

WITH RECOVERY, REPLACE, STATS = 10,

MOVE 'MyDB_DATA' TO 'D:\SQLDATA\MyDB.MDF',

MOVE 'MyDB_log' TO 'D:\SQLLOG\MyDB.LDF'

GO

And I remember that, I have deleted the...

thank you..

OK ,I got it now..thanks

thanks,

I have opened a table in Management studio and changed some row valuse in some columns manually. Now what ever action I did, I want to see it in a...

Thanks,

I tried to find out the Icon but I did not find it. Could plz send a screen shot?

I attached a screen shot, in that I have changed column...

Could you please give suggestions...

Our active node is SQL1. So do I need to select SQL1 OR the Virtual server name SQLVS?

which one you guys select in setting up perfmon counters? Virtual server name...

Hi Irwan Tjanterik,

Are you maintaining share Point databases in SQL Server 2005? If yes please check the MASTER database collations (Master->Properties->collations) and any share point database on that instance...

hello PS,

I have configured this log shipping in sql server 2005 using the Log shipping wizard and the server timings are also correct. Could you please tell me the exact...

No...I'm sure that this log backup Test_20090724230001.trn occurred at 4:00 PM. As you saying it occurred 23.00 but not.

It should have Test_20090724160001.trn as per the date format you are saying...

I'm...

I suggest you use the provided log shipping utilities and just schedule the copy job to run with a slight delay, e.g if the backup job runs on the hour,...

I'm setting up Perfmon counters for clustered sql server instance.

Node1: SQL1

Node2: ...

Hi Greg,

could you please advice me..

thanks

Could you please give me some info on this??