Viewing 15 posts - 1 through 15 (of 16 total)
For a single server scenario does it make any sense to install two instances of SQL, one for application databases and one for Reporting Services/Datamining? Doesn't it defeat the...
April 18, 2012 at 10:15 am
Mhlewis (4/13/2012)
I don't think that will work. To restore a differential, you always have to start with the last full backup and then apply the differential. So every night...
April 16, 2012 at 6:07 am
For our datamining, they're accepting being able to only query data up to 1 day old for their reports.
I'm thinking of going with their backup\restore plan and going with...
April 13, 2012 at 6:03 am
Well, you need Enterprise Edition for database snapshots, so now that leaves me with snapshot replication.
April 10, 2012 at 6:28 am
Mhlewis (4/9/2012)
April 9, 2012 at 2:09 pm
Snapshot as it applies here: http://nirajrules.wordpress.com/2008/12/08/snapshot-vs-logshipping-vs-mirroring-vs-replication/
April 9, 2012 at 12:47 pm
Lynn Pettis (4/9/2012)
April 9, 2012 at 12:31 pm
Lynn Pettis (4/9/2012)
Since you are doing a nightly full backup, why not just restore that backup for your BI/Datamining people?
That's fine for when our database is small, but when it...
April 9, 2012 at 12:19 pm
OK, I'm calling sqcmd from a batch file to delete rows in a table wherever the value in one column matches any items in my text file. Those items...
February 2, 2009 at 10:19 am
Well, I manually edited the DTSX package and removed all paths and just left the file names, which forces it to use %CD%. I had to copy all the...
August 22, 2008 at 7:11 am
I've tried editing the DTS package with notepad to subsitute windows variables like %cd% and it fails miserably. I may have to script the database to CSV file and...
August 22, 2008 at 6:39 am
Thanks ME, I figured it out :p
ECHO ON
SET WORKINGDIRECTORY=%CD%
ECHO %WORKINGDIRECTORY%
CD %ProgramFiles%\Microsoft SQL Server\90\Tools\Binn
@ECHO OFF
FOR /F "TOKENS=6 DELIMS= " %%A IN ('SQLCMD.EXE -S "127.0.0.1\(myinstance)" -Q "SELECT @@VERSION"^| FINDSTR /I "SQL SERVER"')...
July 9, 2008 at 1:07 pm
Here is a batch file I wrote:
SC CONFIG SQLBROWSER START= DEMAND
NET START SQLBROWSER
REM THIS WILL UPDATE THE INSTANCE NAME ON A CLIENT, WHERE THE PC NAME HAS BEEN CHANGED AFTER...
January 16, 2008 at 11:36 am
Viewing 15 posts - 1 through 15 (of 16 total)