Viewing 15 posts - 8,686 through 8,700 (of 9,244 total)
dva2007 (12/6/2008)
i have got sql server developer edition which is having different types.
SQL Server Itanium
SQL Server x64
SQL Server x86
I have got Windows Vista Home on my machine. Which...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2008 at 3:46 am
there do seem to be problems with services running under domain accounts not registering their SPN's, local system works fine.
SETSPN -L
should list all registered SPN's (not just for sql server)
use...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2008 at 12:54 am
a warm server should show very different memory usage
if you've only just started it, monitor for a week or so
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2008 at 12:46 am
how big is the database?
you could use SQLExpress 2005 if its under 4GB
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2008 at 12:44 am
from BOL
Logical and Physical File Names
SQL Server 2005 files have two names:
logical_file_name
The logical_file_name is the name used to refer to the physical file in all Transact-SQL statements. The...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2008 at 12:32 pm
the logical filename is generally used internally by SQL server, changing it to something different after copying the database is something i would defintiely do.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2008 at 12:07 pm
i would re apply SP2 in this case
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2008 at 12:06 pm
Niyala (12/4/2008)
Because it would be much easier for me than adding individual members manually and, therefore, I wanted to import the Builtin\adminstrators.
Alternatively, I wanted to create a login for a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2008 at 5:46 am
its more to do with admin rights on the box, put yourself in the administrators group on the server and watch the little green arrows appear 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2008 at 5:41 am
your welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2008 at 5:37 am
why would you want to allow any windows server admin access to sql server as an admin?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2008 at 5:28 am
anoop (12/4/2008)
Restore database Crew from disk = 'C:\SQL2005Backups\Crew\Full+1730.BAK'WITH move Crew to 'C:\SQL2005Backups\Crew.mdf',
move Crew_log to 'C:\SQL2005Backups\Crew.ldf'
my changes are in red, put single quotes around the logical filenames like...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2008 at 5:22 am
the empty white circles mean you can connect to sql server but you don't have rights to stop,start, restart the windows service(s) for that instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2008 at 5:14 am
clusters are either active\passive or active\active regardless of the number of nodes.
do you really need 50 instances? Remember that when a node fails the resources will be resumed on another...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2008 at 3:16 am
i take it that means you havent changed the account, could anybody else have access to do this?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2008 at 3:12 pm
Viewing 15 posts - 8,686 through 8,700 (of 9,244 total)