1. What do you use for daily full backup - SQL backup on type, disc or third party backup Software (we have BackupExec)?

Ans-I do the 'native' SQL Server backup to...

Double check to make sure the job schedule is set for RECURRING. (Use Enterprise Manager, drill down to Management, expand that, expand SQL Server Agent, click on Jobs. Right click...

I finally was able to set up a test and it's not working. It does concatenate the COL to the number, but I can't get it to use it as...

quote:

---

Finally heard back from the vendor and found out that they had restored the copy of our database to a SQL Server...

Thank you, but which suggestion solved the issue?

It's always good to post what solved a problem, that way others see the final solution if they come across this thread.

-SQLBill

SELECT (SELECT 'COL' + (CAST(DATEPART(MONTH,GETDATE())) AS CHAR(2))))

FROM yourtablename

-SQLBill

Let's start with the table you are inserting this into.

What is the order of the columns? Is it the same as the order in the SELECT statement? Probably not.

If the...

You say the Event Log shows error 208.

Which Event Log?

What does the SQL Server Error Log show?

What does the Windows Event Log show?

-SQLBill

Jonathan,

How about turning that into a FAQ (Resources>FAQ)?

-SQLBill

You posted in the Access forum, but I'll answer as though you meant SQL Server.

You can't do a restore unless you have backups. Autogrow has NOTHING to do with backup...

That's not a large database. I have one that is over 200GB.

Here are some things to consider:

Your system just crashed. You tell your boss you can restore from backups but...

Could your transactions be causing it to grow over the 6000 MB size? If so, that would cause it to fail.

-SQLBill

Do you know about when it's happening?

You could run a trace to capture what's happening.

-SQLBill

I suggest you do a search of the topics, especially in the Backup forum. This subject has been covered quite a lot.

So, look through the forums, find what has already...

What do you mean by disable or limit nested transactions?

The answer is yes you can do either one.

You just don't write nested transactions or you write only the amount you...