Viewing 15 posts - 3,676 through 3,690 (of 9,244 total)
As far as I'm aware you cant. If you try to enable .NET role without internet access you have to use cmd line to disable online checks
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2014 at 10:55 am
muthyala_51 (1/22/2014)
Steve,Can you help me to find that article or elaborate on that technique which you are referrring to?
As follows
ALTER DATABASE olddata ADD FILEGROUP newFG
ALTER DATABASE olddata ADD FILE(NAME=somename, FILENAME...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2014 at 9:31 am
SQL Server data compression would be my preference over NTFS compression
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2014 at 8:34 am
Welsh Corgi (1/22/2014)
The Transaction Log File was backed up 3 minutes ago.Right after the backup the transaction log file was over 5 GB.
Yes but what was the free space inside...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2014 at 8:21 am
Akayisi (1/22/2014)
during work-day i did not want to blow up the our network. Yeah it is working by the way lol
The diff generally wouldnt be too large to do that
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2014 at 8:19 am
I'm guessing by the sudden stunned silence you have fixed it 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2014 at 7:45 am
the first step you need to do is to increase the frequency of your t-log backup. Hourly is definitely not frequent enough, try half hourly or quarter hourly and STOP...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2014 at 7:44 am
if you use sql server auth that will work. For the Windows auth to work you'll need to setup the SPNs and enable Kerberos
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2014 at 7:39 am
The only issue ever caught me was the .net framework install on a machine with no internet access (typical when deploying on a VM), you have to install it via...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2014 at 7:34 am
Akayisi (1/22/2014)
Perry Whittle (1/22/2014)
Akayisi (1/22/2014)
Hi Perry on secondary the output isYayinSistemi_Data219269000000023400116
on primary
YayinSistemi_Data219269000000023400116
In this case you can fix the missing tran log backups issue by taking a differential backup on the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2014 at 7:08 am
Akayisi (1/22/2014)
Hi Perry on secondary the output isYayinSistemi_Data219269000000023400116
on primary
YayinSistemi_Data219269000000023400116
In this case you can fix the missing tran log backups issue by taking a differential backup on the primary and restoring...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2014 at 7:01 am
Akayisi (1/22/2014)
ok now i want to know this.
Suppose that i have trn files which are 1.trn, 2.trn, 3.trn
I know for sure that...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2014 at 5:30 am
schleep (1/22/2014)
I had assumed that the policy would execute under a system/admin account.
But...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2014 at 5:28 am
logicinside22 (1/21/2014)
we have Active/passive SQL 2008R2 cluster environment.
looking for steps to move Data and log files from user Database and System Database for SQL Server Clustered...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2014 at 5:24 am
Ryan Keast (1/22/2014)
This is an account that has Domain Admin rights on the network and certainly has permissions to where I'm trying to back up to.Any ideas please?
Makes absolutely no...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2014 at 5:07 am
Viewing 15 posts - 3,676 through 3,690 (of 9,244 total)