Hi,
having tested SQL mirroring and transaction log backups and failing over to the backup DB's to another server i have come to the conclusion that we need to simply configure the backup server...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23404512.html
as above. have already install 1st and default SQL server instance but cant install a 2nd one! it has sp2 installed also.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2340...
I am using Microsoft SQL Server 2005, 64Bit version running on Windows 2003 64bit. SQL Server seems to be consuming most of the RAM on the server. Our of 8GB it uses 6GB all the time which makes th...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2353...
I have a very largr database that is partitioned into a weekly scheme. I currrently have 104 filegroups with 104 physical files associated. I scripted the creation of these files and I found that...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2362...
I have a production server that's running on Windows 2003 Enterpise x64 bit edition, with SQL Server 2005 x64 bit edition on it. I have the page filing setup on a seperate partition and is set to 1...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2372...
I'm trying to load SP2 for MSSQL Server 2005 on 64bit operation system. It comes up with the error below...the administrator is full control so I don't know what other permissions it's talking abou...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2338...
