For more articles, Please Visit : http://microsoft-sql-server-dba.blogspot.com/
Microsoft SQL Server DBA
This blog is for Microsoft SQL Database Administrator (DBA), one can view the posts and can post their comment/concern to this blog regarding Microsoft SQL Server Administration. The blog will have information related Microsoft SQL Server Administration and latest updates.
Thursday 26 January 2012
SQL Server 2008 different editions...!
For more articles, Please Visit : http://microsoft-sql-server-dba.blogspot.com/
Wednesday 10 August 2011
Good Microsoft SQL Server information sites.
http://www.mssqlcity.com/Articles/Replic/SetupSR/SetupSR.htm
http://vyaskn.tripod.com/iq.htm
http://users.telenet.be/pecop/sqlr/sqlbasics.html
http://blog.sqldbasupport.com/
http://www.aspfaq.com/downloads.asp
http://www.java2s.com/Code/SQLServer/CatalogSQLServer.htm--
For more articles, Please Visit : http://microsoft-sql-server-dba.blogspot.com/
Saturday 6 August 2011
Which system database of which we can't take the backup?
We can't take the backup of the tempdb database and the tempdb database is a universal "scratch" area within SQL Server. The SQL Server engine utilizes tempdb as a temporary storage area when doing sorting and aggregation operations. Applications can also utilize tempdb through the use of temporary tables, procedures, and cursors. You can look at tempdb as serving a function similar to the paging file within Windows. Anything created within tempdb, by its very nature, is temporary. When you restart a SQL Server instance, tempdb is wiped out and re-created.
You should never create any object that is required to be persistent within tempdb, because you will lose anything stored in tempdb when the instance is restarted.
--For more articles, Please Visit : http://microsoft-sql-server-dba.blogspot.com/
How to get list of Database Users
Wednesday 29 June 2011
The basic differences between Primary Key and Unique key are as follows
Sunday 26 June 2011
Microsoft Database mirroring
- The database mirroring is implement only one database at time
- The selected database must be in full recovery mode only (Other recovery mode won't work)
- You can't mirror on system databases like (master, msdb, tempdb, model)
For more articles, Please Visit : http://microsoft-sql-server-dba.blogspot.com/