Viewing 15 posts - 5,866 through 5,880 (of 9,244 total)
Yes you could
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 12, 2012 at 5:52 am
anthony.green (3/12/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 12, 2012 at 5:31 am
David Gugick (3/11/2012)
wizard-driven, easy to
You can script it to and in fact if your log shipping plan involves NATted endpoints through a firewall you have to script it rather than...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 12, 2012 at 1:18 am
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
Viewing 15 posts - 5,866 through 5,880 (of 9,244 total)