Weird.

Have you tried dropping and recreating the profile?

Any difference in connection SET options?

You could use the Database Publishing Wizard:

SQLPUBWIZ SCRIPT -d yourDBName -S yourServerName -U userName -P userPassword scriptFilewithPath

You can download it from here: http://go.microsoft.com/fwlink/?LinkId=119368

In fact it should not go 100%.

You can set a max limit for SQL Server memory using SSMS or sp_configure.

However, SQL Server can (and will) release memory to the operating...

This increases performance! Next time you will query that...

Two options:

1) set up domain trust

2) download the file locally with FTP or SMB and then restore from local disk

george sibbald (3/7/2012)

---

As you only have 4GB of memory and AWE is to enable memory usage above 4GB, AWE is not applicable here.

Unless you see messages in your SQL error...

RESTORE DATABASE yourDatabaseName FROM DISK = '\\UNCPATH\yourackupFile.bak' WITH RECOVERY;

Don't use a mapped drive, use the UNC path instead.

Give the sql server user the appropriate permissions on that path and run the restore command.

Sorry, no way....

The database mail setup wizard has an annoying bug that prevents saving changes correctly when multiple instances are open at the same time: http://spaghettidba.com/2011/07/15/an-annoying-bug-in-database-mail-configuration-wizard/

You may have run into this bug.

Sure it...

HowardW (3/7/2012)

---

PaulB-TheOneAndOnly (3/6/2012)

---

Even if there is an index on "timestamp" column it will not be used because predicate includes a function e.g. TO_DATE()... also, in this particular scenario doing a...

bipan (3/7/2012)

---

@Nchax Phoku

Thanks for you reply.

It further means TSM has its special mechanism of taking SQl backups and its not using any SQL native tsql backup commands for sql db...

In my experience, DB2 on z/OS is often used without indexes and has "logical views" to implement the...