That's because there is no database named test in your system

backup log test to disk=@log_name

Edit the job and Replace the word test with actual database name for which you want...

michelles (11/5/2009)

---

I'm sorry - I'm not sure how to do that. From the toolbox, do I choose "Execute SQL Server Agent Job Task"? I can't seem to paste...

Ideally you should be able to create the backup job using maintainence plan.

However you can create a job manually.

write the following code as a part of a job step and...

1. if you've installed default you can enter a period (.) or 127.0.0.1 or the computer name in the server name if u're connecting to local machine

2. if it's a...

Can u disable TCP/IP and then put the database in single user mode?

Thanks..

i got the answer.

I can do it by using

exec sp_dboption 'pubs'

Thanks Elliot and Alzdba, This is what i wanted. I checked by changing the security audit level and the same is reflecting in the registry immediately.

Thanks again for your help!!

Thanks a lot Jack. That is an excellant video.

Thank you all who went through the topic.

I found the location

Its stored at

HKLM>System>ControlSet001>Services>MSSQLSERVER (or mssql$instanceName)

KeyName > ObjectName

Mirroring is a software based high availability solution that...

http://www.mssqltips.com/tip.asp?tip=1818

This site gives excellant output on what you require.

Though i use the below mentioned script (dont remember the source). It was written by Norm Eager.

SELECT

name AS Login,

sysadmin...

r_prasanna82 (10/16/2009)

---

Hi

Can you try running this query through ur new query window to take backup and please check what error you are facing.

BACKUP DATABASE dbname TO DISK = N'C:\dbname.bak', DISK...

creating a covering index (col1, col2,col3) will be very helpful in queries where you're using all three parameters in the where clause. however, if you try to search with a...

You can perform DML operations. You cannot perform DDL operations on the database when database backup is happening.

Excerpts from BOL:

SQL Server uses an online backup process to allow a...

Yes you can make changes...