Viewing 15 posts - 601 through 615 (of 1,179 total)
I am not sure why backpu is configure like this? msdb is system database and in SIMPLE recovery mode. But you are taking FULL and TLOG backup for the database....
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 9, 2013 at 6:45 am
There are multiple things to look for. In addition to above you can also check if tempdb is growing at the time of any maintenance?
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 9, 2013 at 6:38 am
Thank you and appreciate your overwhelming response.
Cheers!!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 9, 2013 at 3:00 am
What I understood from above post is "Data gnerated at subscriber from 15 sites and replicated to central server". If this is the case central subscriber is the ideal option....
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 30, 2013 at 6:27 am
Please find following link which will give fair idea about SQL Server 2012 licence cost:
However get in touch with Microsoft for latest price; there may be differenct for the different...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 27, 2013 at 6:48 am
Check information from DMVs'like sys.dm_repl_articles for article published and sys.dm_repl_tranhash for transaction being replicated.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 25, 2013 at 1:27 am
Not getting exactly what's the issue. Provide error or screenshot for further investigation.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 25, 2013 at 1:16 am
Check if you can rebuild index online.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 24, 2013 at 8:15 am
What is the status of the database on old production server?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 24, 2013 at 4:02 am
You can get the server configuration information by executing:
sp_configure
Other users and logins information can be obtained from catalogue views like sys.syslogins, sys.sysusers etc.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 24, 2013 at 3:56 am
It all depends on how is your environment. It would be easy to maintain if you create a seperate job catagarize by the type of backup i.e. full, diffrential &...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 24, 2013 at 3:18 am
Check if Change Data Capture (CDC) feature of SQL Server may help.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 24, 2013 at 2:41 am
Good question for core DBA.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 24, 2013 at 1:19 am
Try to capture error through profile.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 26, 2013 at 3:33 am
Do you have any maintenance task for this database? If so track tlog during maintenance.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 26, 2013 at 12:59 am
Viewing 15 posts - 601 through 615 (of 1,179 total)