Viewing 15 posts - 1 through 15 (of 55 total)
Thanks everyone for your response.
I know shrink is bad idea but as Paul said we do it with calculation. We try to shrink the log file to 1/4 of...
February 27, 2012 at 3:22 am
I got that a.size from sys.database_files stores file size in terms of 8-KB Pages and multiplying that by 8192 is to convert it into KB. So let's say a.size...
February 22, 2012 at 1:33 am
I know my basics very much I am not asking you to give me entire code only thing I am asking is a which system table, view, dmos etc store...
October 11, 2011 at 5:58 am
I don't need any third party tools................
October 11, 2011 at 5:48 am
Thanks for quick response.
But both of them will not be giving me estimated number of records fetch by each operator...
October 11, 2011 at 5:38 am
I am now trying to have upload job for server activity run 3 times a day every 8 hr. Also I have given retry attempts and retry interval to 1...
May 12, 2011 at 6:06 am
I am facing similar issue only for Server Activity Collection Set. IT upload job runs for more than 1hr it fails with below error message
the thread "ExecMasterPackage" has timed out...
May 5, 2011 at 5:58 am
I have seen many times that maintenance plans do not completely delete files or throws error. so i would suggest you to write a seperate job may be using vbscript...
March 25, 2011 at 8:23 am
First solution will be to move tempdb to other drive and start sql server.
after that you will not require to failover the mirror database.:-)
March 25, 2011 at 8:21 am
Are you trying to restore from network drive, if yes then please check the network is stable between two servers.
Try verify the backup file....
March 25, 2011 at 8:18 am
Can you please try to explain in detail what permissions you have on sql server and what type of authentication you are using.
March 25, 2011 at 8:16 am
I did this test in my test server, like having sp4 on mirror for sql server 2005 and sp3 on sql 2005 for principal and then configured mirror. I...
March 25, 2011 at 1:29 am
Thanks for your reply...
What I was looking for is will there be any sync issues happening in as my mirror will be on SP2 for 2 -4 weeks while principal...
March 25, 2011 at 1:20 am
Yes it is very much possible if you can create linked server.
November 9, 2010 at 5:58 am
My questions is why do you require select into another table in same database ?
October 8, 2010 at 6:15 am