To Prevent Ad Hoc Error Message

1. Right CLick your server name

2. Choose properties

3. Choose Server Setting

4. Under Server Behavior, enable(check) "Allow modification to be made blah....blah.."

- Did you do that...

If you are pertaining to the Server Login Name then follow this steps

To Prevent Ad Hoc Error Message

1. Right CLick your server name

2. Choose properties

3. Choose Server Setting

4. Under Server...

Thanks guys

David and Matt are right TRUNCATE_ONLY will not backup the logs. I do not know if this is the best way but if your in full recovery model other than...

Thanks for the reply jo & jeff just want to know the details about auto shrink option (dont wanna use it anyways ). Im...

Thanks for the correction homebrew01

If i choose to optimize the backups of my databases meaning i want to assure that i cant always make a point in time recovery what could be the best...

Another thing sir about full,diff and tlog is there a detailed site about this? I mean a detailed steps for every choices?

example:

1. FOr fast recovery - <this steps>

2. FOr...

So for the full recovery to take effect (after shifting from simple to full) I need to make a full backup?

oopsss wrong way of quoting any ways thanks for the fast reply

Do you remember deleting the database and then restoring it again in the server? Because when you restore it (given that you delete it first) will be created again thus...

Anyways theres nothing wrong with it and it does not affect our database im just curious thanks a lot Philcart sorry for so many questions regarding the subject matter and...

Thanks fhanlon.. you do not trust maintenance plan even in database backups?? any error encountered in database maintenance plan?? because in my case database maintenance plan runs smoothly

So in short its normal...?

What about this explanation??

From http://forums.devx.com/showthread.php?t=23773

Truncating the log does not reduce the physical file size. To do that you

will have to use DBCC SHRINKFILE. Truncating...

Thanks for the info and patience  Phil now its clear to me about the difference of database backup and tlog backup. If i will...