Just run checkpoint. You're telling sQL Server to flush to disk, which means it'll clear committed transactions from the log. But, since your logs are currently full, most of the...

Exactly.

Right click on the database...

Sounds like you're in FULL recovery but you haven't been running log backups[/url]. There's no way to bring in a portable drive or something to set up for a backup?...

If you want to find out what is currently running for a long time use sys.dm_exec_requests. You can combine that with other DMOs such as sys.dm_exec_sql_text and sys.dm_exec_query_plan to get...

You could create a linked server on production to your local machine. Then you can use SELECT INTO syntax to recreate the table.

Are you using SQL Server Management STudio? Because...

I wouldn't use both. I'd just use 1222 (which won't work in this case). Too messy in the error log otherwise.

So these are queries and not stored procedures? If they're stored procs you can use the dependency DMOs, sys.dm_sql_referenced_entities and sys.dm_sql_referencing_entities.

Not enough information to suggest a good solution. Execution plans would sure help.

Interesting issue. Do you have monitoring on the server? Does CPU, Disk, Memory use go up in different ways during the multi-file backup than during the single file backup? It's...

Sorry, misunderstood. It could still...

I'd need to see the TSQL script and any error messages.

The most likely reason for Multi-Script to skip a server is because it can't connect to that server.

Oksana March (11/26/2011)

---

Personally, I hate when people tell me to "Google it" or look in Books Online (everyone knows already there is that option, why remind?) Therefore, I'll try to...

SqlNewJack (11/25/2011)

---

So I am currently working on learning more programming languages since it's apparent that I must first land a job in the industry in order to slowly attain Dba...

Lexa (11/23/2011)

---

Grant Fritchey (11/23/2011)

---

Lexa (11/22/2011)

---

Grant Fritchey (11/22/2011)

---

Lexa (11/22/2011)

---

Grant Fritchey (11/22/2011)

---

Lexa (11/22/2011)

---

So far "with recompile" seems to prevent massive issues with the proc where the server becomes unresponsive but it causes...

WHOOP!

Best of luck.

While you're up at 3AM, after changing the diaper, just sit and read...