Viewing 15 posts - 6,676 through 6,690 (of 9,253 total)
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...
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...
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...
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
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...
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 =...
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...
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...
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:
September 2, 2011 at 9:08 am
OK, firstly why is the disk dynamic. Personally i think they should be outlawed 🙂
They're only really useful if you have no hardware RAID system and wish to create a...
September 2, 2011 at 9:05 am
praveen.singh (8/31/2011)
September 2, 2011 at 7:54 am
This I think is your problem
SET DatabaseName = db_name(db_id())
You're setting every single row in your temp table to database name of master (or whatever conext you run the query under)....
September 2, 2011 at 3:41 am
gmamata7 (9/1/2011)
we have the best practice for Optimum performance to have data files asnumber of database data files should equal the number of cores per CPU socket
you shouldnt blindly...
September 2, 2011 at 3:02 am
gmamata7 (9/1/2011)
Method1:Have only one root Drive and have all Mounts Points under that drive
sort of, but i think you are confused with how mount points work. The whole point of...
September 2, 2011 at 2:33 am
BigSam (9/1/2011)
In Services & Applications, right-click SQL...
September 1, 2011 at 8:56 am
Viewing 15 posts - 6,676 through 6,690 (of 9,253 total)