fnostro (1/24/2011)

---

Hey Jeffrey,

I know what you were getting at - the jibes were all good natured in intent, no worries.

if you read my last post I found the cause of...

Hey, wasn't trying to show off or anything - what I wanted to show was that you can get those backup times way down with the right configuration.

And, to be...

Here is another way to create your tally table:

--==== cteTally

With e1 (n)

As ( --=== Create Ten 1's

...

fnostro (1/21/2011)

---

CirquedeSQLeil (1/20/2011)

---

Your full backup takes 8hrs and you only backup the transaction logs once a day? How many transactions a day are you running?

Do you need to be...

This forum is for Microsoft SQL Server 2008 - not MySQL. You will probably get a better response from a forum dedicated to that product.

As for your problem, there...

Craig Farrell (1/21/2011)

---

We actually do use a full install of SQL Server on that box, including a configurations database for storage and if we need temp staging we can do...

Elliott Whitlow (1/21/2011)

---

I would recommend not using that username for anything. In my installations we set the password to some random value that the users don't know, even the...

That would probably be available in a utility that uses Intellisense or formatting. Not something native in SSMS as far as I know.

Michael Valentine Jones (1/21/2011)

---

We have been using centralized servers for DTS and SSIS for several years for packages that mainly produce scheduled customer reporting deliverables like spreadsheets.

A big advantage is...

As long as you have at least one user with sysadmin privileges that can login to that instance, then you do not need to know the sa password.

In fact, you...

I normally...

There are a lot of reasons something like this can happen. It can be cause by the SMB settings on the destination server/host, or various settings on the host.

To...

All versions of SQL Server have the capability of backing up to a UNC share. As long as the service account running SQL Server has access to that share,...

I think those documents are a bit mis-leading and confusing. You have to take the into account the context of the document.

Both documents are referring to enabling this feature...

GilaMonster (1/18/2011)

---

Craig Farrell (1/18/2011)

---

*sprays coke on the screen* Thanks Gus, you just lightened up...