Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Using the Management Studio GUI, I am only able to restore a database to a point in time down to the second. Is this just a limitation of the GUI or if I use a script will it restore to the millisecond I specify?

I'm trying to do it with a script and it 'seems' like it's ignoring the millisecond but unfortunately the date value I'm comparing to is, unfortunately, not necessarily the exact time the record was written so I just want to rule out any possibility that the problem could be because of a limitation of SQL Server.

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

Yes that is a limitation of SSMS. When using T-SQL you can control it to the three millisecond mark. The input is done via a datetime variable so it's bound by the normal datatime data type rules which is precise to the 3 milliseconds.

share|improve this answer
    
Thanks for the confirmation. –  BVernon Aug 27 '13 at 22:50
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.