MS SQL Server/Experts

Recent Answers

2010-03-10 Automated DB Backup:

I was suggesting to use SQL Authentication for testuser. My main goal is to try various things one at a time to help point us in the right direction. For example, if testuser could run the SQLCMD commands

2010-03-08 Automated Backup for MSSQL Express 2005:

Are you sure that when you run the SQLCMD command(s) you are logged in as the same user who is connecting to the server via Management Studio? (Most likely, the Authentication selection in the dropdown

2010-03-05 Automated Backup for MSSQL Express 2005:

OK.. let me know the results of looking at the SQL logs and the event viewer. Also the results of running sqlcmd -S Encoding -E -i D:\Backup\dbbackup.sql from a command prompt. Also, try running

2010-03-05 Automated Backup for MSSQL Express 2005:

hmmmm... I don't use SQL Express so I'm only guessing that it has the same logging features as "real" SQL, but the first thing I would do is check the SQL Logs and the server's Event Viewer for error messages

2010-03-03 Backup Database:

You will, by following the directions on that link, be creating a brand new stored procedure. master is a database which is present in all SQL Server installations. Generally, it is not to be messed