When upgrading SQL Server there is limitation on the direct upgrade possible i.e. you cannot upgrade SQL Server 2000 directly to SQL Server 2012 or later versions. And you cannot upgrade from SQL Server 2000 to 2008 or 2008R2 if
Physical Security It’s important for physical and logical securing the server. Secure the physical access to the server by allowing only the authorized persons to the place of the server. The servers should not be directly connected to the internet.
Rebuilding Log when SQL Server Services were not properly closed and log file is deleted. We have a database that is in a “Recovery Pending State”. We can see “AdventureWorks2012” is in Recovery Pending state. We can check the logs
The need to rebuild Master database comes when it is corrupted and we are not able to start SQL Server Service and getting error like this: 2016-01-01 21:21:20.19 spid5s Starting up database ‘master’. 2016-01-01 21:21:20.23 spid5s Error: 5172, Severity:
Find out the location of Tempdb Data and Log file.
SELECT name,physical_name FROM sys.master_files WHERE database_id = 2
We cannot move the tempdb by detach and attach method or backup and restore method. We can move the Tempdb by Alter Database method.
Alter database tempdb
( name = tempdev, Filename = 'C:\Move Tempdb here\tempdb.mdf')
Alter Database tempdb
(name = templog, Filename = 'C:\Move Tempdb here\templog.ldf')
Restart SQL Server
To attach a database for which we have only the .mdf file and not .ldf file of the database. The methods will work only when the database has been detached properly. Method 1 1. We only have a .mdf file
Open the SQL Server configuration manager. We are moving the master database of Default Instance. Right click on the SQL Server service and open properties. Go to “Startup Parameters”. In the startup parameters ‘-dC:\Program Files….’ is the directory of the
When a database is in SUSPECT state that means SQL Server knows that the database is Inconsistent. The best thing to do when you have a SUSPECT database is Restore a FULL backup. But if you are not having Backups
Sometimes when you uninstall SQL Server you’ll see that SQL Server Broswer and SQL writer are skipped. This nothing to be worry about as SQL Browser and SQL Writer are shared features of SQL Server, nad if they are skipped
The edition of SQL Server “made” for you is the one that fulfills your needs. And the best to place for finding the needs that can be fulfilled by Enterprise, Standard, Express and Business Intelligence editions is msdn itself. The