Viewing 15 posts - 46 through 60 (of 501 total)
I ran into the same error after migrating Analysis Services from 2012 to 2014 and since this is the only post about it online, I figured I would share my...
March 27, 2015 at 10:06 am
I've done this a couple times. Once for a centralized SSIS server for all packages enterprise wide and once to offload SSIS processing for a Data Warehouse. In both instances,...
March 18, 2015 at 2:09 pm
It's the year. The schedule was set to start on 3/2/2012 and since it was back dated to start then, the next run on 3/1/2015 would start at 8:30.
March 3, 2015 at 2:09 pm
Use the following to remove the notification.
EXEC msdb.dbo.sp_update_job
@job_name=N'MyJobName',
@notify_email_operator_name=N''
GO
February 27, 2015 at 1:56 pm
You could add the permissions to the model database so each time a new db is created the permissions are there.
February 24, 2015 at 2:06 pm
Is the database getting set to the bulk-logged recovery model during this time? My guess is that the db is set to bulk-logged and then some maintenance is done that...
February 16, 2015 at 2:18 pm
The smallest you could shrink the log file would be to 1GB because SQL requires 2 VLFs in a log file (8GB log divided by 16 VLFs equals 512MB VLFs).
January 28, 2015 at 3:15 pm
How does the engine know not to put any more data in there, and how long does that situation last?
According to BOL https://msdn.microsoft.com/en-us/library/ms189493.aspx
EMPTYFILE
Migrates all data from the specified file to...
January 22, 2015 at 2:34 pm
Build number 12.0.2430 is for CU 4 which would explain why CU 3 would not apply. It appears the server has already been patched to a higher CU.
January 20, 2015 at 2:50 pm
Sounds like the default log location is no longer there. Under server properties and then database settings, ensure the database default location for the log file is valid. It might...
January 14, 2015 at 3:08 pm
One way would be to:
right click the database>Tasks>Generate Scripts.
Select the 100 stored procs you need to modify and save it to a file.
Then use a text editor to do...
January 14, 2015 at 3:02 pm
Also make sure you format any SQL related disks with 64K blocks.
January 13, 2015 at 2:54 pm
Disk alignment is done in Windows 2008 and newer. It was not done prior (Windows 2003). If you are moving to new disks on Windows 2012, they will be aligned....
January 13, 2015 at 2:52 pm
It can. Synchronous mirroring requires a 2-phase commit to take place which could introduce delays on the principal. A transaction comes into the principal, is sent to the mirror across...
January 9, 2015 at 2:23 pm
You will need to install either the client tools or SQL Server Data Tools on the server that runs the packages. This will install the 32 bit DTExec.exe.
http://msdn.microsoft.com/en-us/library/hh231187(v=sql.110).aspx
Then it's as...
January 9, 2015 at 1:59 pm
Viewing 15 posts - 46 through 60 (of 501 total)