Viewing 15 posts - 76 through 90 (of 1,179 total)
What kind of permission you do have on server and databases?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 20, 2015 at 5:17 am
Yes, Agree with others.
search engine work differently in different version to improve the performance. However while doing upgraded one should keep the db in the original compatibility mode unless and...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 20, 2015 at 5:05 am
Contact your VM admin and ask to check DISK I/O for the drive on which you do have issue. Prefer to perform DISK I/O check on all the drives.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 20, 2015 at 4:51 am
If your database is not production than you can attached mdf file without any ldf file and it will automatically take care of creating new ldf file. check following link...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 20, 2015 at 4:41 am
Thank you and appreciate all your time and interest in writing comments.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 17, 2014 at 11:24 pm
As mention above it is not possible. Why you would like to restore 2008 R2 System db to 2012? What is your objective?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 25, 2014 at 6:24 am
Is the instance name correct? Is SQL recently installed?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 24, 2014 at 11:21 pm
One more interesting querstion and nice explanation. Thanks Andy.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 24, 2014 at 11:13 pm
Have you checked the application side? I suspect it's coincidence. As soon as you execute the SP first time it will take little longer due to compilation but next execution...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 24, 2014 at 6:25 am
What do you mean by archived? Can you pl. elaborate terms archived? Have you implemented any archive solution to database?
Reason I am asking is: in ORACLE it is different...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 24, 2014 at 5:23 am
It depends on how critical it is to verify data and what is the size of the data? Simply you can run the query to all user database to select...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 24, 2014 at 4:21 am
It should be fine as database size is very small. Also think if you shrink and free some space i.e 300-400 MB how does it help you?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 24, 2014 at 4:09 am
Good one! Thanks for the question.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 23, 2014 at 11:42 pm
Are you able to ping the server with sql server virtual name? or ping virtual IP address?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 23, 2014 at 4:40 am
Easy one thanks Steve.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 23, 2014 at 2:53 am
Viewing 15 posts - 76 through 90 (of 1,179 total)