Viewing 15 posts - 181 through 195 (of 1,154 total)
Yeah, you need to take a new snapshot after the restore .
--
SQLBuddy
March 20, 2014 at 10:49 am
Did you configure alerts on top of the LS Alert Job ?
--
SQLBuddy
March 20, 2014 at 10:42 am
Check this ..
http://connect.microsoft.com/SQLServer/feedback/details/758972/ssms-2012-hangs-intermittently
--
SQLBuddy
March 20, 2014 at 10:31 am
True, that's due to MS terminology. The VMem you were referring to should be referred to as Virtual Address Space.
Check these ..
http://windows.microsoft.com/en-us/windows/what-is-virtual-memory#1TC=windows-7
http://windows.microsoft.com/en-us/windows/change-virtual-memory-size#1TC=windows-7
http://msdn.microsoft.com/en-us/library/windows/desktop/aa366914(v=vs.85).aspx
--
SQLBuddy
March 20, 2014 at 10:20 am
NicoNicoNico38 (3/20/2014)[/b]
Thanks a lot for your answer...
But i do not control the TSQL written in Excel by users ...
They have a login/password, they connect via Excel to SQL Server...
March 20, 2014 at 9:57 am
Jeff Moden (3/20/2014)
sqlbuddy123 (3/19/2014)
MyDoggieJessie (3/18/2014)
March 20, 2014 at 7:59 am
True, that could be a resource contention issue, the resource being network. May be the backups are stored on a remote server and a slow network could cause this.
Backups don't...
March 19, 2014 at 4:56 pm
MysteryJimbo (3/19/2014)
Kendra recently posted a new video on Brent's website on this subject.
http://www.brentozar.com/archive/2014/03/get-first-job-dba-video/[/url]
Nice Video.
--
SQLBuddy
March 19, 2014 at 3:41 pm
Check for any resource contention issues on the server that's causing this. Usually this occurs due to poor I\O. Try to find on what are the backups waiting for ?...
March 19, 2014 at 3:35 pm
Can I install an SQL 2005 SP 4 on a Windows Server 2008 Cluster?
Min SP3 required on Windows Server 2008 R2.
http://support.microsoft.com/kb/955725
Is there a way to just move the instances over...
March 19, 2014 at 3:27 pm
dbalmf (3/19/2014)
SqlBuddy123.. Mind If I grab that script..? I was just starting to write something like that.. 😀
Sure, No Problem ..
--
SQLBuddy
March 19, 2014 at 3:19 pm
kaplan71 (3/19/2014)
We utilize a third-party application to do backups of servers. I checked our scheduled backups, and there was a full backup job scheduled to back up the C:...
March 19, 2014 at 3:18 pm
MyDoggieJessie (3/18/2014)
March 19, 2014 at 3:10 pm
That's not possible. Mirror DB is not accessible as it is. May be dummy test db was primary DB on Server B.
You can't use the Mirror DB directly for...
March 19, 2014 at 2:57 pm
kaplan71 (3/19/2014)
I checked the Microsoft Software Shadow Copy Provider and Volume Shadow Copy services, and both indicate they are set to manual, and are not running on the system....
March 19, 2014 at 10:41 am
Viewing 15 posts - 181 through 195 (of 1,154 total)