NORECOVERY: Tells SQL Server that you are not finished restoring the database and that subsequent restore files will occur. While the database is in this state, the database is not yet available, so no connections are allowed. RECOVERY: Tells SQL Server that you are finished…
Category: sql server administration
run this sql: RESTORE DATABASE databasename WITH RECOVERY
my maintenance plan for defrag-ing indexes was failing due to a disabled index ran this to re-enable index: ALTER INDEX [indexname] ON dbname.tablename REBUILD GO
open SSMS – right click on the Server – Properties – Database Settings – Database Default Locations good idea to not have your databases on the c drive
Quick summary: RTM (Gold, no SP) SP1 SP2 SP3 SP4 SQL Server 2011 codename Denali – SQL Server 2008 R2 codename Kilimanjaro 10.50.1600.1 SQL Server 2008 codename Katmai 10.00.1600.22 10.00.2531 10.00.4000 SQL Server 2005 codename Yukon 9.00.1399.06 9.00.2047 9.00.3042 9.00.4035 9.00.5000 SQL Server 2000 codename…
Major Builds Version Build KB Article Service Pack 2 for SQL Server 2008 10.0.4000.00 968369 Service Pack 1 for SQL Server 2008 10.0.2531.00 968369 RTM 10.0.1600.22 N/A Build KB Article Title Description 10.0.4266.00 2289254 SQL Server 2008 SP2 CU 1 The first CU after SQL…
select @@Version SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)
use msdb exec sp_send_dbmail @profile_name = ‘ss job notifications’, @recipients = ‘put email address here’, @subject = ‘live database sizes’, @query = ‘use databasename select db_name(dbid),str(convert(dec(15),sum(size))* 8192/ 1048576,10,2)+ N” MB” as Size from sys.sysaltfiles group by dbid order by 2 desc’, @attach_query_result_as_file = 1;
if you are trying to restore a database from a backup file that is on a network server… the sql server service needs to be running under a domain account that has privileges to the network share you are trying to retrieve the backup file…