Viewing 15 posts - 46 through 60 (of 372 total)
How does the free space and fragmentation level of the local drive look?
Do you see any other processes on that server that might be competing for resources?
January 9, 2009 at 8:25 am
Are you backing up to local drives or across a network?
Some rough estimates on what it would take to transfer a 35GB file at various rates across a network:
10Mbps: 8.5...
January 9, 2009 at 6:12 am
Try adding the location of your scripts to the path environment variable.
PS C:\>$env:path += ";C:\MyScripts"
January 8, 2009 at 7:29 pm
Glad to hear you got it working!
January 8, 2009 at 3:42 pm
Zuke,
SNAC is the abbreviation for SQL Native Client.
I didn't mention this before but I'd highly recommend you setup some type of lab environment with a few servers...
January 8, 2009 at 3:05 pm
Change the account that SQL runs under to a local user account instead of the Local System account. For example, create a normal user account named SQLSVC, then change...
January 8, 2009 at 2:46 pm
Ask that person/company that wrote the application if it supports SQL 2005 database Mirroring. If not, find out what they would recommend for high availability alternatives.
January 7, 2009 at 12:41 pm
If in doubt about the syntax you could always check Books Online.
Did you change the database name, server name, domain name and port numbers to match your configuration?
January 6, 2009 at 5:46 pm
In SSMS right click on your database then select New Query.
You might find this video on SSMS helpful:
http://www.sqlservercentral.com/articles/Video/65066/"> http://www.sqlservercentral.com/articles/Video/65066/
January 6, 2009 at 2:52 pm
From a query window. Same thing you used when checking the endpoints before.
January 6, 2009 at 2:04 pm
1) Offline the principle databases (there are 4 total), back them each up
Before you go any further with mirroring check the section in that article titled Multi-Database Issues. If...
January 6, 2009 at 1:19 pm
The witness doesn't switch the roles of principal and mirror, it's just there so that 2 out 3 agree on who's who.
With the SNAC client you can configure the...
January 6, 2009 at 12:02 pm
How about taking a step back. Try setting up mirroring without the witness first using a test database. Then after you get that working add the Witness. Better to...
January 6, 2009 at 11:37 am
Zuke,
About the log file, my guess is that another transaction log backup had been taken before you took one, maybe run by a scheduled job. You should be able...
January 6, 2009 at 11:09 am
Taking the App A & B out of the equation, can you connect to both instances on that workstation using Query Analyzer or SSMS?
As you pointed out, if you remove...
January 5, 2009 at 2:39 pm
Viewing 15 posts - 46 through 60 (of 372 total)