Avoid using cursors!

Cursors are row based queries, in simple terms SQL defines which rows are required in what can be thought of as a temporary structure. Then when you step...

Page9:F1 (11/18/2010)

---

So I think if I can get rid the replication rebuild, I can reduce the time window for the work.

We cannot make the DB offline or detach directly...

Ann Cao (11/17/2010)

---

I see an microsoft knowledge based instruction of how to backup/restore user databases to a new server, and then transfer logins and sql jobs.

But some one mentioned...

You need to go to the object and change the...

Why aren't you just doing a backup and restore?

You shouldn't have issues with the original database, but the database on the pen drive will be marked as being replicated. This...

The backup backs up the current state of the database. If you did a RESTORE HEADERONLY from BackupDevice... you will see it is expecting 400GB of space. There is no...

If you read the posts carefully you'll see they send the Diff backups to the client every night. This is more efficient than sending a full backup every night.

Then they...

kiranjanjanam (11/8/2010)

---

Yes, it started failing after the very first diff backup..and the daily diff backups are taken in a maint. plan.

and here is the code:

BACKUP DATABASE ABC

...

Did it fail after the very first differential backup?

Just to be sure can you post the differential backup code you use?

Leo

I've got to agree with Craig, differential backup shouldn't break log shipping. I've implemented this before without issues. There must be something else going on, like a truncate log.

Cheers

Leo

Sorry, I didn't realise your restiction was that you had to do ALL the work from the intermediate server. What all can you install on this server? Are they happy...

OK, use BCP or SSIS on the SQL server to dump the files locally, then set up a Windows scheduled job to Robocopy the files through the system. No SQL...

As long as your SQL Server Service account has write access to a drive on the intermediate server you can use BCP or SSIS to create the text files. Serch...

You need to calculate spaceused for a single row,...

What is the function actually doing? Knowing the underlying code and schema would help find a possible issue.

Also if you trace the SQL statements, not only the batch you can...