Viewing 15 posts - 61 through 75 (of 491 total)
you are trying to ask when you will create the file,login or any object in the primary server then these objects will be create automatically on the secondary server or...
June 22, 2011 at 5:01 am
there must be same number of log files on the logshipping Server
June 22, 2011 at 1:28 am
which user you are using SQL or Windows to access the SQL Server ?
If you are using the SQL Login then this will appear everytime when you try to connect...
June 21, 2011 at 11:34 pm
if you have a domain then create a separate ids as
sqlservice for database services
sqlagent for the database agent services
and add these 2 accounts in the server local administrator group and...
June 21, 2011 at 11:23 pm
Do not split more drives on the same RAID group
June 21, 2011 at 11:16 pm
Disk Delays are not acceptable
Maximum Disk delays should not be more than 30 ms,if more than 30 ms then you have to check your SAN storage settings RAID Groups and...
June 21, 2011 at 11:10 pm
yes you can
1-Restore the Full Backup with no recovery
2-Restore the 6am log backup with no recovery Point in time most recent possible
3-Restore the 9am log backup with no recovery Point...
June 21, 2011 at 10:53 pm
whats the subnet mask did you define for the private NIC IP 10.3.10.222 or 10.3.10.223 ?
can you ping each other ?
are these NIC connect directly to eachother ?
whats the subnet...
June 21, 2011 at 10:44 pm
check the LUN mapping of disk drives
these are shared disk or Drive comming from SAN storage?
are you installing this SQL server Installation on physical Server or Virtual Server ?
June 21, 2011 at 10:28 pm
I don't see how this could solve the OP's issue.
If I'm reading it right, (s)he's trying to query SQL2000 from SQL2008R2, not the contrary.
Did you create SQL Server 2008 R2...
June 21, 2011 at 2:20 am
If you have multiple drives not partition then separate drives gives you performance advantage,when you go for the default drive then there are several other processes are running on this...
June 21, 2011 at 2:05 am
install the sql server native client 10 on the side of SQL server 2000 and then create a odbc with this driver and then create a linked server with this...
June 21, 2011 at 1:56 am
MS Access userid and password required
But NOTE it in this process your relationship will not move from access database to sql server 2008,you have to define separately
June 21, 2011 at 12:19 am
First of all check the SAN Cache and then RAID Groups,If All disk on the same RAID Group that might be a problem
Page-Life-Expect..
as asked by the @Old Hand
For Disk...
June 21, 2011 at 12:16 am
Viewing 15 posts - 61 through 75 (of 491 total)