Lynn Pettis (5/5/2010)

---

If the database is using the SIMPLE recovery model, BACKUP LOG will not work, even if you are doing TRUNCATE_ONLY. Also, realize that that is being depreciated...

You are correct in your thinking - if you lose the SAN completely, you'll lose the transaction log backups which would be required to restore to a point in time.

Copying...

GilaMonster (5/5/2010)

---

Jason P. Burnett (5/4/2010)

---

True however, I am not sure that would cause any more growth in your log than suspending your log backups during the duration of the full...

Right-click on My Computer and select Manage.

Open the section for Local Users and Groups

Select the Groups

In that section are...

Eddy! (5/5/2010)

---

Thanks to both dma-669038 and bethrich for your comments as well.

I really want to stay away from switching back to simple model due to not wanting to break the...

Lowell, if that functionality adds the users to the right local windows groups - then yes, that should work. If it doesn't, then it will need to login to...

Before taking the system down and putting SQL Server in single user mode, try adding your windows domain account to the SQL Server specific windows groups on the server. ...

Carl B. (5/3/2010)

---

Hello Jeffrey,

We are using the build-in Rebuild Index task. I don't see any way to enable or disable statistics recomputation in that task.

Any way, lets say that we...

WayneS (5/2/2010)

---

Digs (5/1/2010)

---

Jeff,

All works fine: And Fast !

I will keep your name on my list when I need to spend $$$ on my project .

Minutes have gone down to...

Why not just use the output parameter for sqlcmd itself?

sqlcmd.exe -S $DatabaseConnection_STR -E -w600 -b -d dba -r1 -i $TempInputFile_NME -o $OutputFile_Name

Is that new in 2008 - or can you do it in 2005 also? I knew about drop existing, but did not think you could do it online also....

If you need a specific format for the file - then you have to create your own procedure/code that generates the file name and backs up the database/transaction log.

The default...

Yes, but it does not come with the Express version by default. There is an express version (Advanced) that comes with it, but you have to be aware of...

Sorry - I don't follow, what would reporting services do for you?

I have to agree with the others, good start on posting. I did want to point out one thing that I have found helps me out with dynamic SQL...