Viewing 15 posts - 2,641 through 2,655 (of 9,241 total)
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
Its not clear what you need, do you want detail of all filegroups or just the default filegroup.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2014 at 12:56 am
SQL-DBA-01 (12/4/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2014 at 5:08 am
you're attempting to set the sql data directory to a non clustered drive by the look of it, could you post a screen shot of this section of the installer
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2014 at 4:44 am
Viewing 15 posts - 2,641 through 2,655 (of 9,241 total)