Viewing 15 posts - 31 through 45 (of 79 total)
I think you are talking about the port number. Yes, it is as per your choice/SLA. You can use the default port or change it to a custom port.
Database Mirroring...
July 30, 2010 at 6:45 am
Anjali,
How big the backup file is? If you can access both the servers, then you can manually copy the backup file (provided all access is there).
Else you can...
July 30, 2010 at 6:41 am
This may be helpful:
SELECT SERVERPROPERTY('Edition') as [SQL Server Edition],
SERVERPROPERTY('ProductVersion') as [SQL Server Version],
...
July 30, 2010 at 6:34 am
You may need to configure your firewall to open for the ports, that will be used for the database mirroring endpoints.
July 30, 2010 at 4:07 am
If both your SQL instances are in a domain environment, then you can create a database mirroring operating in High Performance Mode (asynchronous data transfer). The above link will still...
July 30, 2010 at 4:05 am
Here is a link for a step-by-step article on how to configure Database Mirroring using SQL Server 2008
You may need to check whether you need to configure database mirroring between...
July 30, 2010 at 3:44 am
One reason could be that Name reolution is not happening by the DNS server. Check with your Server administrator. Are you able to resolve the IP address to the FQDN....
July 28, 2010 at 5:15 am
Thanks for your advice. When I was attending 70-431, the exam was divided into two parts, One part checks the theoretical knowledge about the product and the other part checks...
July 27, 2010 at 1:19 am
Am planning to take 70-432 next month, is the exam pattern same as of 70-431?
July 27, 2010 at 12:35 am
You need to execute the script from the support website as given above on the server A.
Then execute the following stored procedure on the master database of Server A.
USE [master]
GO
EXEC...
July 27, 2010 at 12:30 am
You need to add the login for the SQL Server instance.
Here is an article, which describes all the state of Login Failed error 18456
July 26, 2010 at 7:19 am
additionally , i would say create a service account( Windows Auth. ) and use that in all jobs .
Normally, the windows accounts bound with a security policy to changes the...
July 26, 2010 at 3:43 am
RESTORE DATABASE MyDatabase from disk= '\\MyServer\MyShare\MyDumpFile.BAK'
Never restore a backup directly from the network share, I am looking forward to it.
July 26, 2010 at 1:08 am
The IP2 is the loop back address for IPv6. Windows Server 2008 supports both IPv4 and IPv6, and by default, both are enabled on the network adapter. You may need...
July 25, 2010 at 8:07 am
SQL Server will be installed on the shared drive, however, some of the shared files will be on C: drive.
July 24, 2010 at 12:57 pm
Viewing 15 posts - 31 through 45 (of 79 total)