Viewing 15 posts - 6,661 through 6,675 (of 9,241 total)
Developer edition does offer all the features of Enterprise just not for a prod environment
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 5, 2011 at 7:57 am
what version were these databases originally, SQL 2008 or a previous version?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2011 at 3:21 pm
unless you're downloading express edition SQL Server 2008 normally comes as a DVD image. The directory structure is totally different to SQL Server 2005. As far as i remember there...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2011 at 12:30 pm
beejug1983 (9/4/2011)
Hi Perry, if heartbeat signal is using private network and anyhow private network goes down then how this heartbeat signal will use public network ?Thanks in advance.
As i pointed...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2011 at 6:35 am
hoover (9/2/2011)
So, a failure of any resource will lead to a fail over.
Important to remember that failure of the dedicated heartbeat will not necessarily cause the cluster to failover as...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2011 at 3:10 am
What account do the reporting services and database engine run under?
Is your login account a member of the local admin group?
Can you supply more detail on the configuration used when...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2011 at 1:48 am
Use the FailoverPartner option in the connection string if you are connecting via ADO.NET or native client. Otherwise you'll have to set up some form of failover detection and dynamically...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2011 at 1:33 am
beejug1983 (9/3/2011)
ok, means ADV.BAK and ADV2.BAK of AdventureWorks db contain the full backup. And if any on bak file get corrupted I wont be able to restore the full backup.
that...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2011 at 10:48 am
manju3606 (9/3/2011)
Hi,I am using local account
If you're running the sql server services under a local account, the local Windows user account needs to be created on each server with...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2011 at 8:34 am
Use the following command
BACKUP DATABASE AdventureWorks TO
DISK = 'F:\MSSQL\Backup\ADV.BAK',
DISK = 'G:\MSSQL\Backup\ADV2.BAK'
WITH INIT
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2011 at 8:30 am
Access denied error 5 is pretty clear. My guess is you have set the share permissions but not the NTFS permissions.
Check the properties for the share below. Then go to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2011 at 11:28 am
Issue the following command to move the data file location within SQL Server. Obviously change the logical name, drive, path and filename as necessary
ALTER DATABASE MyDB MODIFY FILE (NAME =...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2011 at 11:22 am
verify connectivity between the witness and the mirror and the principal and the mirror.
You need to get the session resumed as quick as possible as the log will keep on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2011 at 11:16 am
gmamata7 (9/2/2011)
1. Can we rename the Mount Points after installing SQL Server?
already commented on this 😉
gmamata7 (9/2/2011)
2. How to get the Free space, used space for Mount Points?
go into explorer...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2011 at 9:59 am
you need to get the configuration right from the outset otherwise you're setting yourself up for a fall from a great height :exclamationmark:
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2011 at 9:08 am
Viewing 15 posts - 6,661 through 6,675 (of 9,241 total)