Viewing 15 posts - 30,706 through 30,720 (of 39,754 total)
look up create database and the with attach_log_rebuild_log option to move just the MDF.
Are you backing up the log? What's the recovery mode? There are databases that have valid t-logs...
November 14, 2007 at 4:12 pm
First, this is moved the the SSIS forum. You might get better responses there.
Second, you'd need to do some sort of merge operation in SSIS, looking up values based on...
November 14, 2007 at 3:54 pm
Pagers can handle beer though! My old manager dropped my circa-1990 pager into a pitcher one day when he was tired of it going off. We let it dry off...
November 14, 2007 at 3:30 pm
Very strange. Did you try to save it with a name like trades/mypackage?
Steve
November 14, 2007 at 11:35 am
Just below here, when you're replying, there's a section called "Post Options". I've attached a screen shot. This section stays open or closed, depending on how you last set it.
In...
November 14, 2007 at 7:12 am
Just a bit of humor to get things started 🙂
FYI, you can see the Dash, sans chocolate, here: http://www.t-mobile.com/shop/phones/Detail.aspx?device=f164419f-eee9-4cf6-a1bd-070dbe4b5023
November 14, 2007 at 6:26 am
It will change some things in those databases as this is a "patch" for SQL Server, but you will not lose any jobs or logins.
November 13, 2007 at 8:52 am
tempdb is running in Simple mode, so it should keep itself trunacated on a regular basis. The only thing that remains in there is an open transaction. If you had...
November 13, 2007 at 8:51 am
This appears to be an IE6 issue and we're looking for something else we can do.
If you paste into Word or Wordpad, it should appear ok, then it can move...
November 13, 2007 at 8:25 am
:), my mistake and a very nice post Ewan.
It has been corrected.
November 13, 2007 at 7:45 am
From experience, I usually spent about half an hour checking servers. That was after spending hours building automated systems that could roll up disk space, errors, jobs, etc. into a...
November 12, 2007 at 4:31 pm
Interesting question. I'd think so because you can restore a db from 2000 to 2005.
November 12, 2007 at 4:11 pm
Viewing 15 posts - 30,706 through 30,720 (of 39,754 total)