Viewing 15 posts - 5,866 through 5,880 (of 9,241 total)
gmamata7 (3/8/2012)
We are using lite speed for sql server backups.
If we use lite speed for backups, then do we MUST need to use lite speed for Log shipping too?
Or can...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 11, 2012 at 2:43 pm
balasach82 (3/9/2012)
select top 1 * from TABLENAME where ISDATE(DATEFIELD) = 1
and convert(datetime,DATEFIELD) <(GETDATE-60)
DATEFIELD --> varchar (10)
Since DATEFIELD is varchar,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 10, 2012 at 8:24 am
yes, lauch the installer via add\remove programs, when selecting the component select the SSRS instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 10, 2012 at 8:09 am
charipg (3/9/2012)
I need to install SQL Server 2008 on a Windows Server 2008 Cluster.Please provide the prerequisites and step by step procedure.
Follow part 3 of my guide at this[/url] link
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 10, 2012 at 8:08 am
johnny1walker (3/9/2012)
how i can do;
connect file = test3 data FILE to testgroup2 FILEGROUP
and this
connect file = test4 data FILE to testgroup2 FILEGROUP
LITTLE DETAIL ==>
------------------
ALTER DATABASE test
ADD FILE
(NAME...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 10, 2012 at 7:27 am
Thanks for the feedback
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 9, 2012 at 11:06 am
sqldba.today (3/9/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 9, 2012 at 8:55 am
Because attaching\restoring the reporting databases to the 2008 R2 instance will upgrade the database structure but the internal SSRS structures will not. It is a known issue with SSRS upgrades,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 9, 2012 at 12:33 am
Baabhu is probably going along the right path here. Do you have a maintenance plan on place on this server that rebuilds indexes and maybe shrinks files too?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 9, 2012 at 12:25 am
Which hypervisor are you using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 9, 2012 at 12:19 am
What account are the services for each insurance running under?
Have you checked the SPNs for each instance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 9, 2012 at 12:14 am
ok start by trimming the backup history but dont use getdate(0 -30 cos that will try and delete all history and possibly consume the server. Purge the history in stages...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2012 at 2:20 pm
check your SPNs and enable delegation on the computer account
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2012 at 1:54 pm
whats the date of the oldest history in the msdb?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2012 at 1:47 pm
yes there is impersonation so that when the agent service needs to carry out an admin task it can. However, there is no inheritance, logging into SSMS as the service...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2012 at 1:44 pm
Viewing 15 posts - 5,866 through 5,880 (of 9,241 total)