Ahmed Ibrahim - SQL Server - All Comments

re: Migrating SQL Server 2000 user databases to SQL server 2012

Marx — Wed, 15 May 2013 13:12:54 GMT

Great post. It saved me tons of times. Thanks again.

re: Installing SQL Server 2008 plus Service Pack 3 using slipstream on Windows Server 2012 RC in un-attended mode.

hthefa — Mon, 25 Mar 2013 04:41:40 GMT

this very good

re: T-SQL script to backup all user databases with time stamped backup file.

Ahmed Ibrahim - MSFT — Mon, 11 Mar 2013 11:47:41 GMT

Thanks a lot Troy for the feedback :)

re: T-SQL script to backup all user databases with time stamped backup file.

Troy Hunt — Mon, 11 Mar 2013 11:36:50 GMT

Thanks Ahmed, this was very handy, just one little suggestion: encapsulate the "@dbName" string in the backup statement in square brackets. The script failed for me as is when the DB has a dash in the name.

re: T-SQL script to backup all user databases with time stamped backup file.

Ahmed Ibrahim - MSFT — Sun, 10 Mar 2013 06:00:44 GMT

You can filter user database by modifying below query

select name as DatabaseName

from sys.sysdatabases

where ([dbid] > 4) and ([name] not like '$')

and add in clause to specify certain database names

re: T-SQL script to backup all user databases with time stamped backup file.

aditim — Sat, 09 Mar 2013 12:06:27 GMT

Can you please tell how to use the above script for any particular database or only 2-3 databases

re: Workaround for SQL Server 2012 setup deployment requiring access to Visual Studio media

Heather — Wed, 31 Oct 2012 17:13:55 GMT

I have done all of the posted steps, but still having problem trying to install the vs_setup.msi. Any tips?

re: Workaround for SQL Server 2012 setup deployment requiring access to Visual Studio media

Ahmed Ibrahim - MSFT — Tue, 30 Oct 2012 16:42:37 GMT

Thanks, Sarabpreet for taking the time to read and comment on this blog post.

re: Workaround for SQL Server 2012 setup deployment requiring access to Visual Studio media

Sarabpreet Singh Anand — Tue, 30 Oct 2012 15:50:09 GMT

Helpful Indeed.

Thanks Ahmed for sharing this. :)

re: Installing SQL Server 2012 with Cumulative Update 1 (CU1) using Product update feature

Ahmed Ibrahim - MSFT — Thu, 11 Oct 2012 18:25:03 GMT

Thanks a lot Alberto for having the time to read and comment on my blog and yes this method is supported for Service Packs as well.It is even smart to have the folder C:\SQL2012Updates contain many Service Packs and CU packages and it will go scan and pick the highest applicable version.