Viewing 15 posts - 286 through 300 (of 469 total)
Not sure if changing the recovery model of the database to bulk logged would help in any way, as you are shipping the logs, but if the reindex job finishes...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 15, 2008 at 12:16 pm
Why would you want to free up space by getting rid of data? As there are processes running on the database that need space to run
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 15, 2008 at 11:42 am
Well, we have decided not to put the actual video into the database, as we want to have control over the amount of data that actually goes into the database....
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 15, 2008 at 11:29 am
Database Mail process shuts itself down after a certain period of inactivity. The default value is 10 minutes, which can be changed via Database Mail Configuration Wizard (can be found...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 15, 2008 at 11:25 am
Right click on you server, click on properties and go to the security tab. You can change the authentication mode here. You would require to restart SQL server for this...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 13, 2008 at 7:41 am
Yes- I do believe I need to catchup a lot :hehe: with the encryption feature on SQL. I think this is the right time I do it.
Thanks Gail...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 12, 2008 at 9:52 am
Gail: what if I were to encrypt a single column on request from one of our clients..
1.How is the process supposed to work?
2.How would the process of querying the table...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 12, 2008 at 8:34 am
For 1$ I could give you an advice..set up jobs that alert you with disk space or any errors reporting in the errorlog.
We use an application like 'appmonitor' that queries...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 11, 2008 at 1:31 pm
check the error logs..look in Database Mail folder of the error logs. Lets see what you find..
Thanks!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 11, 2008 at 1:17 pm
2008-12-07 02:57:08.74 spid57 SQL Server has encountered 398 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [d:\xyz\efg_NDX\efgNDX2.NDF] in database [xyz] (8). ...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 11, 2008 at 8:25 am
I don't see any suggestions yet, is there a separate section on this site to discuss Clustering or any other site you people know of that would help me find...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
December 11, 2008 at 7:53 am
We use a general domain\OurNameSQLServer account with SysAdmin privilege...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 21, 2008 at 3:12 pm
Yes, I restore to a point in time before the update..Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 21, 2008 at 1:15 pm
Guess what my server admin tried installing it on our production env and the updates failed. When he brought it to my knowledge I researched on it to find out...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 21, 2008 at 10:58 am
Helps posting links..:hehe:
http://support.microsoft.com/KB/948110
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 21, 2008 at 10:53 am
Viewing 15 posts - 286 through 300 (of 469 total)