Viewing 15 posts - 6,661 through 6,675 (of 9,244 total)
or the fact that its still actually restoring across the network location. Move the backup file locally and run the restore
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 5, 2011 at 11:00 am
I have submitted an article which i hope to have published soon regarding mount points and SQL Server which i hope most will find useful
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 5, 2011 at 10:55 am
SQLJocky (9/3/2011)
So what we ended up doing was to stop the services and start in single user mode and add the new accounts.
thats exactly the process you needed to follow
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 5, 2011 at 8:51 am
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
Viewing 15 posts - 6,661 through 6,675 (of 9,244 total)