Viewing 15 posts - 256 through 270 (of 1,179 total)
how about network?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 16, 2014 at 12:28 am
Are you facing any issue related to tempdb?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 16, 2014 at 12:03 am
You can use check constrain.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 15, 2014 at 11:58 pm
When SORT_IN_TEMPDB option is ON SQL Server uses tempdb to store the intermediate sort results which are used to build the index while reindexing.
It is always good to have TEMPDB...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 15, 2014 at 11:55 pm
I don't think so.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 15, 2014 at 6:17 am
I do not see any blocking.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 15, 2014 at 6:11 am
Could be the permission issue. Any error in SQL log?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 15, 2014 at 1:41 am
What is the status of SQL Server services when you receive this error message?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 15, 2014 at 1:38 am
Disable the antivirus and try.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 14, 2014 at 5:59 am
you can change the query as per your requirement.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 14, 2014 at 5:58 am
can you post result of following command? Where dbname is the database name on which you are facing issue.
sp_helpdb <dbname>
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 14, 2014 at 3:57 am
This is normal.
This is due to internal SQL Server processing. Sometime when query plan is available for your query it will executed immediately. Also in the destination table if...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 14, 2014 at 3:47 am
You haven't updated error from sql error log?
Can you restore with command line?
BACKUP DATABASE <DBNAME> TO DISK = '<PATH>'
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 14, 2014 at 3:35 am
This is normal and happen when your backpu/copy from primary to secondary will take more than 5 min. So restore job on secondary will not find any file to restore...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 14, 2014 at 1:09 am
Have you checked the error log? What information captured in it? Is this production server? Have you executed DBCC CHECKDB?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 14, 2014 at 12:59 am
Viewing 15 posts - 256 through 270 (of 1,179 total)