We are on SQL server 2000(SP3) on Windows 2000. Our disk drive on which Datafiles resides got full. In order to add additional disk space, we...
Satya, Thanks for your immediate response. However, as suggested I have deployed that application. But it gives bunch of details and which process...
Satya, But where you able to identify what was the problem? there should be something wrong when the error occurs. and why it would disappear when...
Hi, Thanks for the update. I have installed the procexp as suggested by you. However, against which process I should monitor against. Moreover in...
Hi Satya, What I am going to gain by increasing the frequency ? Is there any advantage for doing it ? rgds, viral shah
Hi, but this does not tell who is holding the locks on the system ? it only tells whether it is possible to access the file or not. Kindly guide...
Hi Satya, Sorry for asking once again for clarification. So do we can or we cannot reenable the log shipping between Primary and failover database....
The log shipping interval is 10 minutes with 0 minutes delay. Yes I am getting the issue intermittenly and their is no definite pattern. rgds,...
Hi, Since the destination after re-attaching the database would be the original one, still we need to re-configure the log shipping ? our is 250 GB...
Dineshashanka/ Satya, Thanks for your reply. However I checked the referenced link, but I could not co-relate my problem what the link mentions. Is...
We have a log shipping configured between Primary and secondar database. However, due to space constraint on Primary database, we have to de-attach...
We have log shipping congfigured between SAPPROD and SAPFO databases (both are on SQl server 2000).<br /><br />However, we are intermittenly...
Hi, No my database is not divided into file group and the said database is for our SAP system. I checked with my Network and NT administrator and...
Thanks for the update. However, I do not have space on the local server and that's the reason why I am pushing the backup dump to the shared drive...
I am using SQL server 2000 and doing the full database backup(SAPDEV) thru SQL Server. The backup dump file is on the mapped drive on our...
Chappy, Thanks for your detailed input. However, my basic question was whether we can directly spool the output of my T-SQL command into a file...
Thank u all for your expert guidance. In continuation to my earlier question, can we spool out the T-SQL output directly from the screen(like Spool...
Hi, I checked the log shipping monitor and the application log and I saw the following error : Server: Msg 3201, Level 16, State 2, Line 1 Cannot...
Hi, I have successfully configured the log shipping between two SQL server 2000 databases. The configuration was successful and the first...
Hi, Sorry for asking a simple question. Basically I wanted to append the output of the following query : select BNAME,UFLAG from dbo.USR02 WHERE...
Separate names with a comma.
