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...
any update ? ? ? .......i am waiting for the solution......
The links u provided were for SQL 2000 i believe......just check it
Sathya thanks for responding my queries patiently...[<img src='/community/emoticons/emotion-1.gif' alt=':)' />] <br />but i seriously feel MS has...
@db_name = 'Pubscopy',
@backup_log = 1,
@terminate = 1,
@final_state = 3,...
I referred MSDN ,so I strongly believe it is the latest one.Pls refer
Hi Sathya,<br /> Really thanks for your prompt response..........few more doubts are there ! ! !<br /><br /<a target="_blank"...
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.........
Sathya,Many thanks for the info
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...
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...
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...
Database snapshots can be used for
Protecting your system from user or administrator error
Maintaining historical data...
were u able to ping the mail server???is it up?
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...
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.