Viewing 15 posts - 46 through 60 (of 629 total)
Both those values are registry settings that are used when SQL Server starts up; accessible at HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.InstanceName\MSSQLServer
Values to check AuditLevel (values 0, 1, 2)
- 0 - None
- 1...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 16, 2010 at 10:21 am
During install it is a strange error, do you already have a SQL Instance installed on server? But it sounds like the Shared Memory Protocol is disabled.
Go to ...
-...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 16, 2010 at 9:29 am
1) In a cluster some the files for SQL Server are locked on passive node; so therefore after installing SP3 I usually reboot both nodes before attempting anything else.
2) I...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 16, 2010 at 9:22 am
Starting SP3, Microsoft (finally) fixed the security issue. Even if you are part of BUILTIN\Administrators, you will not be granted SYSADMIN on SQL Server (yeeeh!). So you should...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 16, 2010 at 9:14 am
Another suggestion/question, the connections you don't want to kill, is there a different user list that is accessing these tables? Then you can build list of connections that are...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 16, 2010 at 9:12 am
Yeap, no issues. Of course the second instance will be named instance :). Also you'll need to watch out for memory, cpu and disk i/o etc for running...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 16, 2010 at 9:07 am
my 2 cents...
two questions ..
1) what is the block size on the disk where tempdb is being created?
2) is tempdb sharing the same disk as your data file?
other general comments
unless...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 13, 2010 at 3:39 pm
Don't get down bud, first time I did mirroring I was pulling my hairs out also.
It is a strange problem you are getting for two hosts not be to be...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 13, 2010 at 9:03 am
I never used SQL Authentication for Database Mirroring; how are you configuring that? Can you please show the SQL Statement you are executing?
Have you tried to create connection using...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 12, 2010 at 3:25 pm
Start endpoints on both servers.
Go to first server, and open telnet connection to 2nd server using the endpoint port. If the connection establishes (aka the telnet window stays open);...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 12, 2010 at 2:46 pm
Execute ...
SELECT *
FROM sys.database_mirroring_endpoints;
Check to see if the state_desc is STARTED. If not then execute
ALTER ENDPOINT [EndPointName] STATE = STARTED
I haven't done Mirroring for a while, but you can...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 12, 2010 at 1:14 pm
Simple answer to that question is, it depends.
It depends on type of change you are doing, for all changes recommend full db backup for small databases; or roll...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 12, 2010 at 11:35 am
I am going to say no to that, because I have seen database/application that only one database can be on server. Or others where have 200+ databases on server.
There...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 12, 2010 at 11:29 am
Going to throw this out, although the error is not recorded here. When using linked servers in stored procedures or functions the RPC must be enabled on it. ...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 12, 2010 at 11:18 am
DBA in Unit 7 (8/12/2010)
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 12, 2010 at 11:02 am
Viewing 15 posts - 46 through 60 (of 629 total)