Viewing 15 posts - 1 through 15 (of 32 total)
You can change your login name via t-sql. Heres a link on it.
September 20, 2011 at 12:41 pm
The ISO is probably just the first cd. You most likely wont need the second cd to do the edition upgrade and therefore done need to worry about the folder...
September 2, 2011 at 1:59 pm
I have had to do an install from hard disk before. You can try these steps, but they are from SQL 2005. This should still be relevant though.
http://support.microsoft.com/kb/916760
Just make sure...
September 2, 2011 at 12:42 pm
Theres an ftp task in SSIS, but if you cannot log onto the website to download the file then another way would be to create a SQL job. You could...
August 17, 2011 at 2:14 pm
to make sure the single user command works you could run this, which will rollback any transactions that are running on the database.
ALTER DATABASE [YourDbName]
SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
More details...
August 16, 2011 at 12:46 pm
That would be for an in-place upgrade.
I would recommend installing fresh instances of SQL 2008 on new servers and migrating the databases over. You will encounter less headaches this...
August 16, 2011 at 12:30 pm
Hi,
Please explain how you are trying to connect. If from a remote server you will need to make sure tcp/ip or named pipes are turned on in the sql configuration...
August 10, 2011 at 12:27 pm
My understanding of using the overwrite is the file is replaced with the restored database.
August 9, 2011 at 12:59 pm
You do not need to change the policy settings for this service account. What HowardW mentioned should be all you need to do. Here are the basic steps.
1. Just log...
August 9, 2011 at 12:55 pm
if you use the overwrite option during the restore then it will succeed, but the data will be overwritten. Thats the only way I could see the restore being successful....
August 9, 2011 at 12:42 pm
Check the folder path that you defined in the Define Maintanence Cleanup Task window. The sql service account will need permissions to this folder. Also this path cannot be blank,...
August 9, 2011 at 12:33 pm
I am talking about the second book you posted. That is a great book for this exam.
July 28, 2011 at 12:44 pm
Ive used the training kits in the past for the '05 exams and they are great. Im studying right now for the 70-432 and im using the MCTS-Self-Paced-Training-70-432-Pro-Certification book. I...
July 28, 2011 at 12:31 pm
It sounds like a database with that name already exists on the test server. You can choose a different name or on the Restore wizard go to options and click...
July 18, 2011 at 12:36 pm
Viewing 15 posts - 1 through 15 (of 32 total)