Viewing 15 posts - 4,756 through 4,770 (of 9,244 total)
sej2008 (10/17/2012)
in workgroup environment using administrator as a user and password of principal,mirror and witness servers is the same.
Endpoint are different...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2012 at 1:19 am
Vegard Hagen (10/17/2012)
The version number in the file properties (and in server properties inside Management Studio) lets you know exactly what...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2012 at 11:50 pm
Yes, it's SQL Server 2005 SP3
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2012 at 2:34 pm
ok, the path shown is atypical of a SQL server 2005 installation. Confirm this by browsing to the sqlservr.exe and open the file properties, on the version info check the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2012 at 2:16 pm
JimS-Indy (10/17/2012)
Binary install path???
Asked myself the same question. Is it on the properties sheet and I missed it? I looked.
find the service name in services.msc and right click then select...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2012 at 11:46 am
Have you renamed the Windows server since sql server was installed?
To remove the current servername entry use
exec sp_dropserver 'abcxyz'
Then run this to correct it
exec sp_addserver 'abcdef', 'local'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2012 at 11:41 am
JimS-Indy (10/17/2012)
Note Capture 5 -- SQL Server Configuration Manager.Capture 6 -- Server Manager.
Binary install path???
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2012 at 7:48 am
JimS-Indy (10/16/2012)
See Capture 4
well, according to the output you only have one instance of SQL Server and it's a default instance. Go into services.msc and right click the service
SQL Server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2012 at 4:53 am
Its still not clear what you want to do.
Which version\edition of the Windows OS do you plan to use for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 17, 2012 at 4:03 am
Books online states that if no target size is specified, a shrink-file operation removes only the inactive virtual log files beyond the last active virtual log file in the file....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 16, 2012 at 3:07 pm
Really need to get an idea of the current file sizes, post the results of this please run against your database
USE YourDB
GO
selectname
, size / 128 AS FileSize
, case max_size
when -1...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 16, 2012 at 1:45 pm
kkanaya (10/16/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 16, 2012 at 12:58 pm
Number of indexes?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 16, 2012 at 12:56 pm
open a cmd prompt on the machine and post the output of
NET START
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 16, 2012 at 12:12 pm
david.washington (10/16/2012)
Great article.
just out of interest which article were you reading?
Paul Randal (10/16/2012)
My goodness - what a load of utter nonsense in this article.
I actually didn't want to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 16, 2012 at 11:58 am
Viewing 15 posts - 4,756 through 4,770 (of 9,244 total)