Viewing 15 posts - 5,686 through 5,700 (of 9,722 total)
Then it's my bad.
June 20, 2011 at 9:37 am
opc.three,
I think you're mixing this post up with another thread. There is no requirement for 60 days in the OP that I can see. The OP says "all files."
June 20, 2011 at 9:07 am
You can query on sys.Filegroups.
June 20, 2011 at 9:04 am
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
Viewing 15 posts - 5,686 through 5,700 (of 9,722 total)