Viewing 15 posts - 361 through 375 (of 931 total)
GilaMonster (8/10/2011)
If not, the database will come up in recovery_pending then you'll have to...
M&M
August 10, 2011 at 1:43 am
Great article by Paul. Good question, like to see more of these.
M&M
August 10, 2011 at 1:05 am
There should be some good tools available in codeplex site.
Have you tried searching there?
M&M
August 9, 2011 at 4:49 am
naresh.talla (8/9/2011)
Hard disk size is 300gb free space is 100gb,already the database is there we are just replacing that database.
You might need to drop the existing database and then try...
M&M
August 9, 2011 at 4:38 am
you can try using SSIS
M&M
August 9, 2011 at 3:07 am
You could check this link.
http://www.mssqltips.com/tip.asp?tip=2384
There are few more in the 'Next Steps' section, may be of use to you.
M&M
August 9, 2011 at 2:32 am
August 9, 2011 at 1:48 am
forsqlserver (8/9/2011)
How to kill a sql server agent running job?
Right click on job and stop it
How to check how many jobs are currently running?
Go to Job Activity monitor as see...
M&M
August 9, 2011 at 1:31 am
Try to create a linked server to that instance and then fetch data.
M&M
August 9, 2011 at 1:01 am
Brad, nice question. Need more from you on this topic.
By the by, your blog posts are cool. 🙂
M&M
August 9, 2011 at 12:59 am
Just type sqlwb on Start->Run and see if Management Studio comes up?
M&M
August 8, 2011 at 10:31 am
Good one Grant, thanks for sharing.
M&M
August 8, 2011 at 8:47 am
abhishek_dwivedi03 (8/8/2011)
????The query has been executed for that particular database only .
Please help if something can be done from my side.
Thanks
Use this,
select name,log_reuse_wait_desc from sys.databases where name ='your db...
M&M
August 8, 2011 at 5:32 am
Viewing 15 posts - 361 through 375 (of 931 total)