Viewing 15 posts - 5,686 through 5,700 (of 9,715 total)
Script tasks in SSIS work with C# and VB.Net. If you don't know these languages, I advise you to steer clear of the Script Task and use the File System...
June 20, 2011 at 6:58 am
dec_obrien (4/2/2007)
When you backup the database, what happends the log file?
Absolutely nothing. Database backups don't even look at the log file. Transaction Log Backups, however, are a different story entirely....
June 20, 2011 at 6:56 am
Not sure you need VS installed to create an SSIS package. The SSIS Import / Export wizard could create the package for you. You would, however, need to have SSIS...
June 20, 2011 at 6:54 am
If you've attempted a design and failed, please post the DDL code and data sample so we can point out where your errors are. We'll be happy to help you...
June 20, 2011 at 6:51 am
If it's the same database each time, why not create a job for the restore, with the login fix as a separate step, and then give the Dev permissions to...
June 20, 2011 at 6:48 am
It definitely sounds like someone renamed a folder and didn't bother to update the log shipping job.
June 20, 2011 at 6:46 am
GSquared (6/20/2011)
June 20, 2011 at 6:44 am
The database is working fine, but are you positive the file / filegroup is online?
EDIT: This article is for R2, but it almost mirrors the BOL 2005 entry on File...
June 20, 2011 at 6:39 am
If you're reaching your data limit, why would you be questioning how to increase the memory size? Data size and memory size are two different things and should be treated...
June 20, 2011 at 6:35 am
It definitely sounds to me like someone is doing something, like changing the recovery model back and forth or restoring the database, both of which can break the LSN.
June 20, 2011 at 6:33 am
Where are the ReportServer and ReportServerTempDB databases located?
June 20, 2011 at 6:27 am
Other workarounds include setting up the Alert system for errors x, y, and z. But you seem married to your script. And I don't know of any singular system db...
June 20, 2011 at 6:26 am
Ewan Hampson (6/20/2011)
SQL Server should have a health warning about system databases and backups
That's what the DBCC commands and the Alert system are for. You should only have to worry...
June 20, 2011 at 6:16 am
Also, check and see how often your job log clears itself out. That would be the reason why you're not seeing a history on the job.
June 20, 2011 at 5:54 am
Check the Configuration Manager for SQL Server. Someone may have turned off Named Pipes as a protocol.
EDIT: Also, check the box that the application is running on. Did someone turn...
June 20, 2011 at 5:50 am
Viewing 15 posts - 5,686 through 5,700 (of 9,715 total)