When in doubt, normalise. Besides, normalization will help as you expand your project, like say you want to add a table for responses and or possible responses. Provide...

John is correct, this can be done without the use of backup devices. You can backup the database directly to a local file and then copy that file onto...

Dana

Using Management Studio, right click on the server, then select Security, in there is the option to select server authentication

John is correct. It is only a backup of the committed transactions, not the entire LDF. So, back to the original issue, 2 Gigs of committed transactions in...

Daryl

I've always assumed it was the size of the log file and planned for it to be that way, however, john posted earlier that it wasn't, so I'll have to...

The SQL Server OU is part of Active Directory, so you have to check with your network admins to get it set up. ONce set up, they should...

Agree with Steve, collecting 2G of changes in 20 minutes is a heck of a throughput. What I suspect is that your log file size is already 2Gs and...

In SQL Server, all jobs are run based on the credentials of the account that the SQL Server agent is signed in as.

When you developed your package, you...

In the full mode, log files grow until backed up and once the file has grown it does not resize as SQL Server automatically assumes that the current size of...

I don't think it's a best practice to restart SQL server unless you are having some type of issue with resources, such as the tempdb becoming too large and must...

The witness server serves as sort of a tiebreak vote to decide which server is the primary. Without it it's like Gore/Bush, the server's won't know who won the...

There is actually no difference to set up an AD account in the database to a SQL Login when it comes to groups/roles.

Hopefully you were given rights to...

Definately not a missing table. Remember the * bring back all objects not just tables. My money is either a Stored Proc or ufn

Just remember to let us know how this works out. Also, besides, company, I want to know the Director of IT or whomever is over the programming there. ...

If you are dedicated to the SQL Server craft then you will find that it becomes easier each day. You can not learn it all at once, in fact,...