Viewing 15 posts - 15,391 through 15,405 (of 39,824 total)
Try shrinking to a larger size, if that makes sense.
Pick a size that is larger your minimum and include that in the shrink.
August 8, 2011 at 10:18 am
Ninja's_RGR'us (8/7/2011)
Very interesting topic Steve.Could it be possible that there's a missing link in this part of the editorial?
This piece talks about the problems with the
Yes, link missing....
August 8, 2011 at 10:18 am
Peform a restore, get an I/O error at some point. Part of the IO error contains a set of operations needed to complete a transaction. The completion of the transaction...
August 8, 2011 at 10:13 am
Looks like when doing the restore or attach, you alter the location there.
August 8, 2011 at 10:07 am
You'll restore a lot more than just jobs, and I wouldn't recommend this. The msdb restore is really for DR purposes. I suspect it would be OK, but I wouldn't...
August 8, 2011 at 10:02 am
My vote would be either compat mode change, or alter the code to use RTRIM instead.
August 8, 2011 at 9:59 am
First, the users are always there. They might not be linked to logins, but the users are in the restored database. If you have the same logins, you can use...
August 8, 2011 at 9:55 am
I tend to agree with Gail, though you could just install 2008 as a named instance, set both instances to manual, and only run the one you need.
August 5, 2011 at 2:59 pm
I would say that if you feel comfortable answering questions about any of the topics listed on the MS site, you'll be fine. The questions are not overly tricky, and...
August 5, 2011 at 2:58 pm
Open Access, select Database Tools on the Ribbon, then there's a "Move Data" section. Choose SQL Server, follow the wizard.
August 4, 2011 at 2:30 pm
cengland0 (8/4/2011)
And, to make it clear, I am a libertarian, but we do not have a libertarian government in the US. I want one but don't have one. ...
August 4, 2011 at 2:24 pm
I don't know if there is a complete way from SQL/SSIS, but Access has an upsize wizard. Does that not work?
August 4, 2011 at 2:13 pm
michael wang-201906 (8/4/2011)
August 4, 2011 at 1:38 pm
Jack Corbett (8/4/2011)
GSquared (8/4/2011)
GilaMonster (8/3/2011)
Tom.Thomson (8/3/2011)
August 4, 2011 at 1:36 pm
GSquared (8/4/2011)
August 4, 2011 at 12:25 pm
Viewing 15 posts - 15,391 through 15,405 (of 39,824 total)