I'm not being snarky that comment is a subtle hint.

The old

EXEC sp_attach_db @dbname = N'AdventureWorks2012', @filename1 =

N'C:\Somepath\AdventureWorks2012_Data.mdf', @filename2 =

N'C:\Somepath\AdventureWorks2012_log.ldf';

The new

CREATE DATABASE database_name

ON PRIMARY (name=mydb_data, filename='d:\somepath\mydbdata.mdf')

LOG ON (name=mydb_log,...

Jason Shadonix (2/13/2013)

---

But that's just a minor syntax change in the process. [/Quote]

You're joking right? Create and alter database have been enhanced extensively to include extra commands (file management, mirroring,...

balasach82 (2/13/2013)

---

My database files are in 1 drive. My database has grown huge andwill keep on increasing in size. To better utilise the disk space and to manage the db,...

It's the supported way of moving database files and doesn't involve dropping the...

balasach82 (2/12/2013)

---

We have an 600gb database as a single mdf and ldf. Due to various reasons, we are planning to split them into multiple files (4) as,

Database_Data.mdf

Database_1.ndf

Database_2.ndf

Database_3.ndf

Database_4.ndf

Database_log.ldf

I have decided on...

Check the output of the following query for top consuming tables and post their names

USE msdb

GO

SELECTOBJECT_NAME(i.object_id) AS TableName

, ISNULL(i.name, 'HEAP') AS IndexName

, i.type_desc AS IndexType

, p.partition_number AS PartitionNo

, p.rows AS...

The issue only seems to be affecting local disks too, all my windows 2012\sql server 2012 VMs are on ESX5.1 and are using iSCSI disks not VMWare virtual disks. I...

That is exactly what it is targeted at!

kevaburg (2/12/2013)

---

what happens if you want to move the master...

where did you check the bindings?

double check the TCPIP settings for each NIC and report back

sismb8 (2/12/2013)

---

Nice article. Thanks! Introduction of the move file technique has been a welcome advance in SQL Server. In the bad old days (SQLServer 6.5/7.0) I used...

As a SQL Server\Oracle DBA i disagree. Oracle has no concept...

You need to throw a dog a bone here my friend, what you've given is not very helpful. Can you...

which problem?

Very little, you still have a clustered SQL Server service and a clustered sql server agent service. Now, if you're asking the differences between Windows 2003 clusters and Windows 2008...

With that level of knowledge you're not leaving yourself much margin for error!

The first thing you will want to do is to check the current hardware against the Windows Server...