No.
ROLLBACK is used with a TRANSACTION only - you start a transaction, and either commit it after making changes or roll it back if there is a problem. You cannot roll back without an active uncommitted transaction on the same connection.
The best way is to restore from your most recent backup.
If you don't have backups, then you are probably in a world of pain. Some of these may be able to help you:
restore deleted data sql server[
^] - but I'd look very carefully before trying any as you may make the problem worse, not better. Either way, you are talking about a lot of work...
Submit an article or tip