Viewing 15 posts - 121 through 135 (of 173 total)
I presented this idea to my SAN admin. I don't think he's was very enthusiastic about the idea.
(? °?°) ????
July 26, 2012 at 1:56 pm
In activity monitor right click on the process and select details.
July 12, 2012 at 10:14 am
I had one machine have an issue with installing the data tools. It was a dev sandbox server so I didn't spend enough time to figure it out before...
July 12, 2012 at 9:24 am
You responded to yourself before I could. But yea, in my 2008 R2 cluster (windows and sql), we've added several drives to live prod nodes without issue.
June 1, 2012 at 12:07 pm
A, I really like the folks I work with, it's a very cooperative team that respects each others skill sets. There are a lot of growth and learning opportunities,...
June 1, 2012 at 10:54 am
Dean Cochrane (5/31/2012)
...and many people who should know better treat the relational database as nothing more than a file system with built in backup capability.
This is, to my experience, more...
May 31, 2012 at 12:31 pm
That's a tough question because like so many others... it depends.
What does your current load look like?
May 24, 2012 at 3:34 pm
All of our dev, and stage environments are VM, about half of the prod machines are virtual now. We're in the middle of the slowly migrating everything over to...
May 23, 2012 at 1:47 pm
Have you verified the operators are valid, and the email profiles for the operators are valid? Can you sent a test email?
May 16, 2012 at 11:50 am
What happens when you run in it management studio?
Do they show up in the logs?
May 16, 2012 at 11:07 am
You can also build your own monitoring solution, and sql server has a lot of built in monitoring and notification parts.
There a bunch of different 3rd party solutions...
May 16, 2012 at 9:55 am
Are they using different logins? Though they are sitting next to each other do they use the same switch? Any other users have issues or just these two?
May 15, 2012 at 11:08 am
What kind of VM? Is this VMWare?
Do you see any events in the tasks and events tab of vSphere?
What do your application, system, and sql server logs...
May 15, 2012 at 10:37 am
I use something like this for mine.
RESTORE DATABASE [MYDB] FROM DISK = N'P:\data\Tdrive\full.bak' WITH FILE = 1, replace,
STANDBY = N'P:\Microsoft SQL Server\MSSQL.2\MSSQL\Backup\ROLLBACK_UNDO_MYDB.BAK', NOUNLOAD, STATS =...
May 15, 2012 at 10:13 am
Here's something I cobbled together as a base for something similar. May be handy for you, may not. Only works for 2005+
SELECT
'restore database [' +
...
May 8, 2012 at 4:36 pm
Viewing 15 posts - 121 through 135 (of 173 total)