Viewing 15 posts - 7,216 through 7,230 (of 9,244 total)
invaliddba (3/28/2011)
An instance and a sql server are not the same though.
Microsoft refer to each instance as an instance of SQL Server 😉
They are one of the same
March 29, 2011 at 4:59 am
ok so you have a TCP alias setup as SQL03 which points to SQL03,1433 or SQL03\SQL03 does this make sense?
Open sql server configuration manager and go to SQL Native Client...
March 28, 2011 at 3:36 pm
check the following registry key and post the values
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo
Also check this for the port number in use by the instance
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.x\MSSQLServer\SuperSocketNetLib\Tcp\IPAll
March 28, 2011 at 2:48 pm
paulnamroud (3/28/2011)
Thank you PerryI give it a right to the user name SQLServerMSSQLUser$xxx and now It works fine!
That looks like one of the local groups created during the SQL...
March 28, 2011 at 1:54 pm
Windows 2003 or 2008 cluster?
What does this return
SELECT SERVERPROPERTY('Servername')
March 28, 2011 at 1:42 pm
Kenneth
what does the following return when executed against the instance
SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS ComputerName,
CASE (SELECT SERVERPROPERTY('ISCLUSTERED'))
WHEN 1 THEN 'VirtualName = ' + CAST(SERVERPROPERTY('MachineName') AS NVARCHAR(25))
WHEN 0 THEN 'Not Clustered'
END AS VirtualNetworkName,
ISNULL(SERVERPROPERTY('Instancename'),...
March 28, 2011 at 12:42 pm
paulnamroud (3/28/2011)
March 28, 2011 at 12:32 pm
SQL Guy 1 (3/28/2011)
That's amazing! Thanks a lot, Perry. Actually I can use it not only for backups or restores, but for anything else.
You're welcome
March 28, 2011 at 12:27 pm
This should help
selectst.text,
command,
db_name(database_id),
start_time,
DATEADD(ms,estimated_completion_time,
...
March 28, 2011 at 12:02 pm
Abrar Ahmad_ (3/22/2011)
1. Is there any performance benefit of segregating database files on different logical drives (physically single storage medium)?
The only gain here is for administration purposes, no performance...
March 24, 2011 at 9:21 am
Hi UMG
It's to large to post as an attachment I can email to people as requested
March 23, 2011 at 3:52 am
what "other boxes" are you referring too
March 18, 2011 at 4:26 am
suri.yalamanchili (3/17/2011)
I am running three VM's in all on my laptop.
You should have 4 VMs
NAS VM
Domain Controller VM
2 x Cluster nodes
suri.yalamanchili (3/17/2011)
March 17, 2011 at 1:17 pm
I would use
Full backups .BAK
Diff backups .DIF
Log backups .TRN
March 16, 2011 at 4:41 pm
odeonkreel (3/14/2011)
I have no need or desire to retain anything in db2 when I restore db1 into db2.
so, as already stated when restoring DB1 over DB2 use the REPLACE option...
March 16, 2011 at 4:38 pm
Viewing 15 posts - 7,216 through 7,230 (of 9,244 total)