Then you need to figure out what uses TempDB and whether it's correct usage or not, and whether there are transactions left open that keep the log from being reused.

Sounds like the backup was taken too early (and hence isn't quite in-sync with the replication).

You need to take the backup after creating the publication.

Create the publication. Set the options...

The script you posted, that you said you use to identify the foreign keys, will do exactly that, identify the foreign key constraints. It gives the table name and the...

ALTER TABLE <table name> DROP CONSTRAINT <constraint name>, instead of ALTER TABLE <table name> NOCHECK CONSTRAINT ALL. Make sure that you can put them back afterwards, and that they...

You cannot truncate a table that is referenced by a foreign key. It doesn't matter whether the constraint is enabled or not. If a table is referenced by a foreign...

The smallest one that supports the query.

While you can create a nonclustered and a clustered index on the same column, there's usually not much point in doing so. Unless the...

Your error was "log file is full". Full, meaning that the entire space in the file had been used up and there wasn't space available. That means the file is...

There's no 'nolog' anywhere in SQL. All data modifications are logged. Some (like...

Siten0308 (4/4/2016)

---

we ran into an issue were the store procedure that gets used a lot, was causing the SQL server to peak performance, only after our sr DBA ran a...

What kind of monitoring do you have on this server?

You can, but I don't know what you expect that to achieve.

The error said that the log was full, that is, the log...

We're missing the most critical information needed for a DR design.

What's your RPO and RTO?

What kind of disasters are you protecting against (for example, clustering won't protect against a SAN...

EXISTS (or NOT EXISTS in this case) can be cleaner and more intuitive as to what it's doing over a join/is null check.

Using John's tables

SELECTb.id

, b.name

FROM@records r

join@books b...

It won't work.

ALTER DATABASE requires that the session running it can connect to the DB. If the DB is...

Ok, so write the query. You had it almost right and you've had enough hints as to how to correct it.