0
votes
1answer
410 views

SQL Server 2008 Error when restoring DB backup: “specified cast is not available”

I was using SSMS to restore a database backup onto another database in a SQL Server 2008 instance, when I received the error message: "specified cast is not available". The backup was made on a SQL ...
0
votes
2answers
227 views

SQL 2008 R2: How to determine who restored the database?

Our database was recently restored. It caused some real grief. Is there an audit mechanism to determine who executed the most recent restore? Thanks.
3
votes
2answers
2k views

Command line scripts to restore the 4 system databases of MS SQL Server 2008

can someone give me some advice on how to restore the 4 system databases (master, msdb, model, tempdb) of a sql server 2008 please? I've already done some testing myself (on restoring the master ...