1. Stop your SQL server if it is runnig

2. Run command prompt (click start then run, type cmd then click OK)

3. Type...

Of course you can do it:

BACKUP DATABASE MyDatabase TO DISK = '\\myserver\myshare\MyDatabase.bak' WITH INIT

Do not forget to provide the folder level permissions on a shared folder (myshare in my example)...

Go to the origin::-)

http://msdn.microsoft.com/en-us/library/ms187910.aspx

Everything is possible,:-) but probability of this situation is very low if your SQL login's password are strong and long enough.

I would say 12 characters with numbers, capital letters, etc....

So, create a scheduled job and use a statement TRUNCATE TABLE Your_Table_Name as a Step of this job.

Don't forget to replace a table name with a real one in...

If you want to...

How to restore your database to Point-in-Time:

http://www.databasejournal.com/features/mssql/article.php/3530616/Point-in-Time-Recovery.htm

Thank you for update.

I would recommend to place your question also on a RedGate SQL Backup forum, usually they are very responsive.

http://www.red-gate.com/messageboard/viewforum.php?f=102

I would give the head user the db_securityadmin fixed DB role.

Then db_securityadmin can manage fixed database roles membership (db_datareader, db_datawriter, etc., but not db_owner) on database level only. He...

Chris Howarth-536003 (9/22/2009)

---

I'm at a loss as to why others are suggesting that the log should be manually truncated, particularly as tempdb is in 'simple' mode and, therefore, should be...

Silverfox (9/22/2009)

---

it is a best practise, we have 16 cpu machines here, tempdb is split, 1 mdf and 15 ndf. size has to be the same, I normally set them...

mathewspsimon (9/22/2009)

---

hi lowell,thanks for the help.2 questions apart from SELECT * FROM [ReorderS] where Item is not null there is one more count.so it is acually SELECT * FROM [ReorderS]...

So, Your line of code should be like that:

EXECUTE master.dbo.xp_delete_file 0,N'\\cmsphdb\sqlbackups\',N'trn',N'2009-09-21T09:23:16',1

Do you mean "How to attach database?"

Right click on Databases->Attach and then point to the .mdf file.:-)