hi just try to restore from QA instead of enterprise manager....prior to this type sp_who2 in Query analyser and check which spids are using the dbs...
Sathya, any update ? ? ? .......i am waiting for the solution...... Regards Deepak SQL DBA
Sathya, The links u provided were for SQL 2000 i believe......just check it Regards Deepak SQL DBA
hi friend, pls refer http://deepakinsql.blogspot.com/2007/06/how-to-configure-log-shipping-in-sql.html...
Sathya thanks for responding my queries patiently...[<img src='/community/emoticons/emotion-1.gif' alt=':)' />] <br />but i seriously feel MS has...
Hi Sathya, EXEC msdb.dbo.sp_change_primary_role @db_name = 'Pubscopy', @backup_log = 1, @terminate = 1, @final_state = 3,...
Hi Sathya, I referred MSDN ,so I strongly believe it is the latest one.Pls refer http://msdn2.microsoft.com/en-us/library/ms175106.aspx...
Hi Sathya,<br /> Really thanks for your prompt response..........few more doubts are there ! ! !<br /><br /<a target="_blank"...
Hi All, I am little confused in the way how log shipping has been changed in SQL Server 2005. I read the whole of articles in BOL to find that...
Hi,why dont u shrink individual files instead of dbs using dbcc shrinkfile......... http://msdn2.microsoft.com/en-us/library/aa258824(SQL.80).aspx...
Sathya,Many thanks for the info Regards Deepak SQL DBA
Hi, • log_shipping_plans • log_shipping_plan_databases • log_shipping_databases • log_shipping_plan_history • log_shipping_monitor •...
Satya,its obvious that we need to enable the restore job......fyi its already in enabled state....but it is getting failed as i mentioned earlier due...
Dear Friend, I just have a doubt,all you mentioned is absolutely right.But the in last step i don't think u need to start the restore job...
hey, last week i had faced exactly the same issue while restoring a SQL 2000 DB which has a compatability of 65,so i changed it to 80 and took a...
Hi, Database snapshots can be used for Protecting your system from user or administrator error Offloading reporting Maintaining historical data...
Hi Pavan, were u able to ping the mail server???is it up? Regards Deepak SQL DBA
hi, pls find the below link for ur question........ for moving user dbshttp://support.microsoft.com/kb/314546 u can use the conventional backup and...
Thanks for your prompt response Sathya........when i gave the startup parameters in GUI as -c -m -T3608 the sql services are starting fine but wen i...
Hi friends, i guess im not duplicating this topic......i have the following scenario in SQL 2000, I tried in the enterprise manager,by...
Separate names with a comma.
