Viewing 15 posts - 5,671 through 5,685 (of 9,707 total)
chris.caines (6/20/2011)
They appear to be, if I query sys.master_files:
CCT_MSCRME:\DATA\CCT_MSCRM.mdf 0ONLINE
CCT_MSCRM_logF:\LOGS\CCT_MSCRM_log.LDF 0ONLINE
FYI: Your .mdf file is not the same as a...
June 20, 2011 at 7:14 am
ravisamigo (6/20/2011)
How can I configure that database server to reportserver to generate Reports?
Ravi, looking at this question, I just realized I don't understand what you mean by it. Could you...
June 20, 2011 at 7:11 am
Grant Fritchey (6/20/2011)
polasabhushan (6/20/2011)
June 20, 2011 at 7:05 am
polasabhushan (6/20/2011)
But I can say that, before taking a full or differential backup, we are truncating log by changing recovery model from bulk-logged to simple and again to bulk-logged.
That's your...
June 20, 2011 at 7:00 am
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
Viewing 15 posts - 5,671 through 5,685 (of 9,707 total)