Sql Server Error: The primary data or log file cannot be removed from a database

Posted by Sqltimes
On May 31, 2013
0 Comments

Another quick one: Sometimes when you are try to move data/log files from one location to another you employ the option of moving all the objects from the file and emptying it out. Then using ALTER DATABASE we could try to delete it. But when you do that we run into this error. [sourcecode language=”sql”] […]

Posted by Sqltimes
On May 30, 2013
0 Comments

Although the day started as just any other day, it is ending with a great surprise leaving much desired satisfaction and motivation. I had an opportunity to use MERGE in a production environment. It was a few years ago (I think so), that I first heard about MERGE statement and got excited and learnt all […]

Posted by Sqltimes
On May 28, 2013
0 Comments

Guys, a quick post. Sometimes when you run SHRINKFILE on the log file we get this error: [sourcecode language=”sql”] Cannot shrink log file 2 (DBADB_log) because the logical log file located at the end of the file is in use. (1 row(s) affected) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [/sourcecode] […]

Posted by Sqltimes
On May 16, 2013
0 Comments

Quick one: Using this query you can check the size of a database file and track its growth in the last few days. MSDB database, when it performs backup, I guess it measures each databases current file size (and other calculations) before performing a backup. So we could leverage this data to map the overall […]

Posted by Sqltimes
On May 9, 2013
0 Comments

Guys, There is a huge collection of free electronic books available on Microsoft website for some (or most) of their technologies. This link may or may not last for too long. Grab what you need soon !!! http://social.technet.microsoft.com/wiki/contents/articles/11608.e-book-gallery-for-microsoft-technologies.aspx I downloaded High Availability book and read one of the chapters. It reaffirmed the solution we implemented […]

Sql Server Error: The primary data or log file cannot be removed from a database

Sql Server: MERGE statement (a powerful tool)

Sql Server Error: Cannot shrink log file because the logical log file located at the end of the file is in use.

Sql Server track database data file size increase for any given database.

Free electronic books for Sql Server and more from Microsoft