Viewing 15 posts - 3,631 through 3,645 (of 9,241 total)
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
bugg (1/26/2014)
To allow the current log to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 26, 2014 at 3:04 pm
Firstly, DONT TYPE IN CAPS, its extremely rude 😉
To shrink the log file the first step you have accomplished, setting recovery to simple. Next issue the following
DBCC SHRINKFILE (Logfilename,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 26, 2014 at 2:39 am
IT researcher (1/22/2014)
1)I have a database which grows about 300 MB every...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 24, 2014 at 7:15 pm
Viewing 15 posts - 3,631 through 3,645 (of 9,241 total)