Viewing 15 posts - 2,641 through 2,655 (of 9,244 total)
Siva Ramasamy (12/8/2014)
I am just going to leave it as it is for now.
Pointless in my opinion, remove it before it fills up too much and then gets cemented in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 8, 2014 at 10:44 am
plamannkathy (12/8/2014)
I have tried doing sql server backups to a file share and that has been taking too long. So I've decided to backup locally and then taking those...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 8, 2014 at 7:04 am
on the SSRS instance properties you will need to enable host headers resolution.
IIS does not and indeed should not be used to manage SSRS instances, the configuration settings are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 8, 2014 at 7:02 am
There's just no helping some people!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2014 at 12:40 pm
Conor Lillis (12/5/2014)
sp_msforeachdb '
--if (''[?]'' not in (''[master]'',''[model]'',''[tempdb]'',''[msdb]'',''[reportserver]'',''[ReportServerTempDB]''))
BEGIN
use [?] ;
--print ''Working on [?]''
select...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2014 at 12:30 pm
Siva Ramasamy (12/6/2014)
It only had one data file (size 350GB). I added another data file (10GB) as soon as I noticed this
Why, what made you think this is even...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2014 at 12:10 pm
When you create the view on the primary its mirrored to any secondarys just as it would in database mirroring and log shipping.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2014 at 12:00 pm
Grant Fritchey (12/5/2014)
Perry Whittle (12/5/2014)
ian_massey (12/5/2014)
But I don't have any access to the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2014 at 4:21 pm
Try this
use MSDB
GO
SELECT bs.database_name
, bs.recovery_model
...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2014 at 7:55 am
ian_massey (12/5/2014)
CASE msdb..backupset.type
WHEN 'D'...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2014 at 7:53 am
ian_massey (12/5/2014)
But I don't have any access to the log file backups, the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2014 at 7:47 am
Ed Wagner (12/5/2014)
When you take a log backup, it applies to the last full backup.
Nope, they're LSN based and are based on the last log backup hence the log...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2014 at 6:46 am
satter (12/4/2014)
Talking with them now. Going to try restoring a t-log from a backup first and see if that helps any.Thanks for the help.
temporarily add a new t-log file...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2014 at 5:04 am
can you post details from the sql error log
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2014 at 5:01 am
how are they taking backups, have they indicated this?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2014 at 3:50 am
Viewing 15 posts - 2,641 through 2,655 (of 9,244 total)