Viewing 15 posts - 1,966 through 1,980 (of 2,904 total)
You say you got it to work. Great news.
However, what enabled you to solve the issue? Was it one of our suggestions? Or one of your own?
Post the solution here...
June 17, 2004 at 11:24 am
Please post your question in an appropriate forum.
This forum "Question of the Day" is specifically for comments on the Question of the Day (QOD). The QOD is a test question...
June 17, 2004 at 8:48 am
Just don't do it! Unless you really have to.
Nothing works better for backup and recovery than using the SQL Server commands.
I backup my databases to hard drive and then use...
June 16, 2004 at 2:47 pm
Also, as I said search the articles on this site for information on restoring the Master database.
-SQLBill
June 16, 2004 at 2:43 pm
When you use Antares' method (via Enterprise Manager) on the General tab there is the option for making the login use SQL Server Authentication or Windows Authentication. You will want...
June 16, 2004 at 2:39 pm
Another possibility....did your Veritas backup of the operating system backup ALL the files? If so, then the files the maintenance plan created when it did the backups should have been...
June 16, 2004 at 11:39 am
What happens if you connect using just 111.22.33.44?
I have two instances on my server. I set my ODBC connection to the IP only (no instance). Permissions on SQL Server do...
June 16, 2004 at 10:56 am
Try this:
1. In Enterprise Manager, find the database. Right click on it and select Properties. Go to the Data Tab and find the name of the data file. Do the...
June 16, 2004 at 10:52 am
What's wrong with the size of the message box?
If you mean that it only displays one line, you might want to check your browser version. There was a problem...
June 16, 2004 at 10:47 am
It sounds like Veritas MIGHT have been trying to VERIFY the final results. See if there is an option to just do the restore without data checks (verify, whatever).
I backup...
June 16, 2004 at 8:06 am
Permissions. The services (SQLServerAgent and MSSQLServer) all run under either the local admin or domain admin account. Will that account change with the change of the domain? Probably.
IP Address. Will...
June 16, 2004 at 7:55 am
Let me see if I have this correct...
You have a SQL Server up and running. You used Veritas to backup the Operating System and SQL Server maint plan to backup...
June 16, 2004 at 7:48 am
Here's one way:
IF EXISTS
(SELECT Name
FROM <dbname>..SysObjects
WHERE Name = '<tablename>')
<rest of code>
Replace <dbname> with the name of the database the table should be in.
Replace <tablename> with the...
June 15, 2004 at 12:27 pm
Network documentation just means any documentation that your network admin may have created.
Has the SA password been changed?
Has the password for the SQLServerAgent service changed? Is the account a domain...
June 15, 2004 at 12:23 pm
With Veritas, the Open File Option won't work with SQL Server .mdf and .ldf files. You need the Agent for SQL Server.
What exactly are you trying to do? What happened?
Are...
June 15, 2004 at 12:19 pm
Viewing 15 posts - 1,966 through 1,980 (of 2,904 total)