I would like to restore a 250GB database (data Mart) to a development enviroment.
I know u cannot choose tables in Restore ?
some tables are in a filegroup, and it is absolutely ok that i exclude them?
shanj, the following will work- use caution when you use REPLACE. if possible test in the test box before taking to Dev.
1) This will do a regular backup- it backs up everything
BACKUP DATABASE [STAGE_T_ORDERS]
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…