Press Alt+F1 for a selected table name in ssms editor, and see the results.

Very handy script.

However, I found a little bug, and here is a recommendation for the little change in the script.

Replace ip.[column_name] with '['+ ip.[column_name]+']' in two places.

Having column names...

The max memory that you could use with standard edition is 128GB. Go with max, if you can allow it.

Execute this code

select d.name,mf.name,mf.physical_name

from sys.databases d

inner join sys.master_files mf on mf.database_id=d.database_id

Jeff Moden (5/16/2015)

---

Igor Micev (5/14/2015)

---

Hi All,

Just to share with the sql folks that the problem was resolved by upgrading the instance with CU1 and CU2. Now there is no issue...

Hi All,

Just to share with the sql folks that the problem was resolved by upgrading the instance with CU1 and CU2. Now there is no issue with the backup process.

Thanks...

Digging ... it's possible the matter that I have added some new files across the databases without restarting the instance. Reading one KB says that it had been a bug...

Perry Whittle (5/12/2015)

---

There is no medianame specified in the query below!

Igor Micev (5/10/2015)

---

Then i run the Command in ssms

BACKUP DATABASE [F1SB] TO DISK = N'F:\SqlBackup2014\<server>\F1SB\FULL\IGS-DB01_F1SB_FULL_20150510_214455.bak' WITH NO_CHECKSUM, COMPRESSION, ENCRYPTION (ALGORITHM...

Yes, actually all the time I'm specifying it. I even change the drives where I'm trying to backup on....

This is the read-in dump file with WinDbg, but I cannot get some useful info as I'm not good enough for system core. Maybe someone could say something?

Perry Whittle (5/11/2015)

---

It's still possible to revoke permission to a windows admin, the advantage that being...

Grant Fritchey (5/11/2015)

---

Durations suggest that the other backup is failing same as the native backup. It sure looks like a permissions issue. Running it as yourself is going to be...

GilaMonster (5/8/2015)

---

Primary key != clustered index.

A table can be a heap and have a primary key

A table may have a clustered index...

duncanburtenshaw (5/8/2015)

---

Igor Micev (5/8/2015)

---

Try this:

UPDATE [temp]

SET Abstract_area = tmp.DataSet

FROM #TEMP1 [temp]

INNER JOIN ( SELECT...

Try this:

UPDATE [temp]

SET Abstract_area = tmp.DataSet

FROM #TEMP1 [temp]

INNER JOIN ( SELECT T.* ,

...