Viewing 15 posts - 3,676 through 3,690 (of 9,241 total)
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
muthyala_51 (1/22/2014)
Perry Whittle (1/21/2014)
What steps have you taken so far?
I used the command COMPACT /C /S source destination to compress all the read file groups. It worked fine. But I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2014 at 4:58 am
Are you using Log shipping or your own variation of it
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2014 at 4:26 am
What steps have you taken so far?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 21, 2014 at 2:11 pm
Viewing 15 posts - 3,676 through 3,690 (of 9,241 total)