Paul Randal (9/28/2012)

---

Too many ambiguities in your post and question. For instance, the 'end' of what? Page? Database? Backup file?

Can you give the exact set of steps and T-SQL, from...

Have been playing around with intentionally corrupting database files and database backup files to see how the various commands that have been discussed so far will behave. This is on...

Superb! Thanks!

Oh yes, getting back to my original question, is there anyone using sqlcmd.exe to backup databases? Or has this become 'obsolete'?

Rahul The Dba (9/27/2012)

---

Hi

this one is really a needed article.

But apart from this I want to know one thing, that is I have a store procedure made by myself for...

Paul,

I have a few automated backups running in various places.

They typically are started via a .bat file launching sqlcmd.exe with the -i parameter pointing to the .sql file issuing the...

Phil,

Can you name some of these 'new generation of databases'/'NoSQL' products/attempts/failures.

Thanks.

Shawn,

I read up on this MLM stuff.

Very wicked indeed (gets even compared to Ponzi schemes).

I find it difficult to see how a sales person at node level 1042 appears to...

Shawn,

In the real business world, I have encountered hierarchies around 15 nodes deep. They're fun. Where in the real world (business or not) have you encountered a hierarchy "a few...

Ben,

Exactly what kind of syntax is this SQLSERVER:\SQL\localhost\default?

I can understand that in place of 'localhost' you can put the computer name and in place of 'default' you can put the...

Ariel,

It's under Start/All Programs/Accessories/Windows PowerShell

I have SS2008 Express and don't seem to recall that PS 2.0 was needed for the installation.

I installed PS 2.0 using the download shown in...

I do backups frequently from my computer which is different from the server on which the database resides. But I want the backup to end up on my computer. This...

I think I will follow this series. It makes it look all very simple. And I'm curious to see what you can do with it in regards to SQL Server.

Just...

Jeff, what exactly do you mean by "Unit 0"?

Never dropped my punched cards - ever.

As for that sequence number, I never knew about these card sorters. But it's a bit like not knowing all of that new stuff...