Viewing 15 posts - 13,726 through 13,740 (of 39,818 total)
HowardW (5/21/2012)
Restores can't be as fast by definition, as you don't have a backwards path to a point in time restore (Oracle has Flashback, a kind of reverse transaction log),...
May 21, 2012 at 9:54 am
SSMS works against Azure databases, so you can use that.
As far as migration, you connect with TDS and then move the data. Red Gate's Data Compare will work, as...
May 21, 2012 at 9:49 am
I'm not sure that you can count on the diff to be the size of data change. I suspect that changed extents in there are included, but if anything changes...
May 21, 2012 at 9:47 am
No. you're looking for some type of delayed resolution or a scalar replacement at run time, but that's not allowed.
You can't do a
declare @c varchar
select @c = 'Sales'
select * from...
May 21, 2012 at 9:43 am
That is old, and it's not something you normally do. I'd agree with Michael's advice.
Can you check the recovery model and post the exact code being used?
May 21, 2012 at 9:40 am
Jeff Kelly-310227 (5/21/2012)
I'm currently testing this with IBM's svc flashcopy manager.
These types of specialized SAN apps are fully SQL aware and use VDI (same as Microsoft's...
May 21, 2012 at 8:44 am
I assume you have queries to get this data? If not, you'll need someone to help you write a query. If you have questions on that, post some DDL and...
May 21, 2012 at 8:26 am
SQLRNNR (5/18/2012)
What is the link for trifecta?
Sorry for the delay: http://www.rmtechtrifecta.com/
May 20, 2012 at 8:26 pm
How can you apply transaction logs to a running database? Forget about the snapshot, how can you apply a transaction log to a database that is running without ever doing...
May 19, 2012 at 8:30 pm
Each time you post, you can set a new default.
May 19, 2012 at 8:29 pm
Note that if you have the R2 or 2012 versions, they won't attach.
I tend to like the 2008 version since it has the Filestream stuff. If you don't need that,...
May 18, 2012 at 3:58 pm
SQLRNNR (5/18/2012)
In Boston now getting ready for SQL Sat 142.If you are close by, come check us out.
Enjoy! I'll be speaking downtown in Denver tomorrow at the Rocky Mountain Tech...
May 18, 2012 at 1:48 pm
Brandie Tarvin (5/18/2012)
I am so tempted to do the Holy Grail joke as a QotD.Steve, would you approve such an animal if I sent it in?
Perhaps for a holiday. Can...
May 18, 2012 at 12:23 pm
TravisDBA (5/18/2012)
Steve,
Agreed, 12 is manageable for most users I think. 20 is just overkill and it is the default. You must also keep in mind that many of our users...
May 18, 2012 at 11:19 am
No way. What you are doing is saying, can I restore T-logs at any point in time to my production databases. That's what an OS snapshot is.
The answer is no....
May 18, 2012 at 10:57 am
Viewing 15 posts - 13,726 through 13,740 (of 39,818 total)