Viewing 15 posts - 3,631 through 3,645 (of 9,244 total)
ayemya (1/27/2014)
HiCan I install SQL server instance on application drive (example E:) in primary and secondary server instead of C: for AlwaysOn availability group?
Thanks.
Ayemya
As long as the instance is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 27, 2014 at 3:18 pm
jayoub (1/27/2014)
I just found out that the SAN Admin provisioned the disk to only the one node Z010 and did not include the other node Z009 in the storage software.
Thats...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 27, 2014 at 12:26 pm
bugg (1/27/2014)
Last question , the mirroring is set up in Safe Mode with no witness so if I pause mirroring will the principal still be able have read...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 27, 2014 at 9:05 am
george sibbald (1/27/2014)
I don't like having a layer of obfuscation between me and my backups.
In fact the only level of obfuscation is on the part of a 3rd party as...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 27, 2014 at 8:58 am
jayoub (1/27/2014)
I will give it...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 27, 2014 at 8:33 am
george sibbald (1/27/2014)
ah, I see. Its a personal preference but I don't like having a layer of obfuscation between me and my backups.
A personal preference which i'm sure a lot...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 27, 2014 at 7:49 am
Jpotucek (1/23/2014)
I have several databases that have high amounts of unallocated space like this:
MYDatabase (dbsize)8037.00 MB(unallocated space)4665.81 MB
This info was obtained by running sp_spaceused.
What...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 27, 2014 at 6:34 am
george sibbald (1/27/2014)
Perry Whittle (1/27/2014)
Given the relatively low cost of licences for these products, they make excellent sense and IMHO are more flexible than native backups 😉
other than encryption, what...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 27, 2014 at 6:30 am
avdhut.k (1/27/2014)
I am using Sql Server 2008 R2,
We used to create Jobs at daily basis,
My requirement is to delete Jobs,on or before...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 27, 2014 at 6:21 am
venkatdbait (1/27/2014)
Is it possible to work logshipping on cross platforms as below mentioned ?
Primary server :windows server 2003 & sql server 2005 sp3
Secondary Server :windows server 2008 &...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 27, 2014 at 6:11 am
Once you add the new disks you must add them as a dependency to the SQL Server service cluster resource, this will require a restart of the clustered service
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 27, 2014 at 6:08 am
bpc0n335 (1/24/2014)
I realize this was an ancient post, but I also noticed that the last login date associated with your profile here on SQLServerCentral is fairly recent, so I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 27, 2014 at 6:06 am
Just about all the mainstream 3rd party backup products (SQLBackup, Litespeed, etc) offer backup encryption and can be used in conjunction with compression. Something which is currently limited natively.
Given the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 27, 2014 at 4:58 am
IgorMi (1/27/2014)
I'm making a change of the database properties, so enabling ALLOW_SNAPSHOT_ISOLATION to ON. I'm doing this only once, i.e. I'm checking for the property snapshot_isolation_state in sys.databases.
Than within...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 27, 2014 at 4:54 am
squeekz01 (1/26/2014)
I am looking for help with writing what some may find as a basic query... I need to be able to scan all tables in my database for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 27, 2014 at 4:48 am
Viewing 15 posts - 3,631 through 3,645 (of 9,244 total)