Good points! I another thing I was trying to avoid having to expand columns on my key/value table as the data has the possibility of becoming more complex (e.g. Stores...

You guys are getting side tracked! 🙂

Let me rephrase the question:

Has anyone used a parallel network file moving software that they would recommend?

Thanks!

-Tristan

Do you get the same / similar error when connecting via Profiler?

Maybe try to do a manual transaction log backup and see if it shrinks down. If it does, you might have an issue with your plan.

Are you doing transaction log backups? Does your database need point in time recovery, or do you depend on full backups? If you're in FULL recovery mode your database log...

Sounds like SQL Server Browser not started, ports being blocked (1433 / 1434) or protocols disabled. Look in configuration manage under network protocols and make sure that TCPIP and Named...

Hello,

Thanks for the response. A lot different than I would have thought and I learned a few things here. Thanks for the information.

If you have a constraint on the columns saying that there has to be at least 11 characters in each, you could do:

SELECT col1,col2,col3,col4 FROM Table1 WHERE LEN(tel1 + tel2...

How are you trying to backup the database? Through Management Studio, query window? How big is the database / log?

Easiest way to do this is through an SSIS package. Just open SQL Server Business Intelligence Development Studio, open new integration package, from your toolbox, drag / drop Transfer Jobs...

Well, if it's a single query growing the tempDB to 200GB, I assume it takes a long time to run. You could run: SELECT max_logical_writes, qt.text FROM sys.dm_exec_query_stats AS...

If you're currently employed, find someone in the company in charge of development or administration and make friends with them. Express your interest in SQL and ask them to give...

Hello Ram,

net start / net stop commands shouldn't be an issue. Here's a good article on doing so: http://vyaskn.tripod.com/restart_sql_server_service.htm

It appears that the 'tblc_audit_acct_grp' table has a foreign key reference to the tbl_audit_master table. You'll need to drop the foreign key reference from the tblc_audit_acct_grp (FK_tblc_audit_acct_grp_tbl_audit_master) and then rerun...

Have you tried recreating the plan? If it's a simple maintenance plan backup, recreating will only take a few minutes. If you have, do you get the same error?