Why aren't you backing up the transaction log?

What is the best way to shrink the log file with out losing the data?.  Backup the transaction log and then run DBCC...

Please post in an appropriate forum. This forum (QOD or Question Of The Day) is strictly for discussing the Question of the Day. The QOD is a daily 'test' question...

I have changed recovery mode on my user databases with no problems. I have never had to switch it to single user mode. Just make the change.

However, you can NOT...

The only way I know is to make it a string:

SELECT '+' + (CAST(100 AS VARCHAR(3)))

-SQLBill

If you have SQL Server, the Books OnLine is SQL Server's HELP. It's installed as part of the Client Tools and you can find it at Start>Programs>Microsoft SQL Server>Books OnLine....

Your transaction log will grow, so you will need to do:

1. make sure there is enough room for the log to grow

2. make sure you allow the log to grow...

Don't quote me, but it's possible that you are doing the differential too soon and the full backup has not 'marked' the database as being backed up. So the first...

BTW- Do a TRANSACTION LOG backup NOT a FULL Backup. Do a full one and you'll lose the chance to recover the data.

See the Books OnLine for BACKUP LOG commands.

-SQLBill

Do you have a full backup?

If so, RIGHT NOW, backup your transaction log. Immediately. The transaction log backup will have everything that occured including the delete.

Now you have a full...

Check the Books OnLine for BACKUP DATABASE and BACKUP LOG.

I suggest doing a FULL backup once a day and several TRANSACTION LOG backups during the day.

To recover the database you...

Have you ASKED the other DBA's if they added the logins?

-SQLBill

The way I see it is....who is the database for? You or the users?

If it's you....set it up the way you want it. If it's the users....set it up their...

What you asked for is kind of confusing....let me try to reword your question and you let us know if this is what you want....

You want a query that returns...

Probably the only way is to run Profiler and capture the commands being run.

-SQLBill

If you do a search of this site (especially the backup forum) you will find a lot of information about this message. The question you asked is asked just about every...