Viewing 15 posts - 586 through 600 (of 966 total)
You will still be logged in while trying to run the command. I do not think it will work. Maybe you could do it scheduling a SQL Server Agent job.
October 26, 2012 at 1:54 pm
Have you looked at Quest's website or tried Google? Quest's installation guides have sections dedicated to performing silent installs.
October 26, 2012 at 1:53 pm
Are you running log shipping on the same database(s) that you also have mirroring on?
From the sounds of it you had a database setup for log shipping and mirroring,...
October 26, 2012 at 1:48 pm
not sure if this helps yet, but i think the issue is a WINS issue when you cannot resolve by name;
For example if you enter SERVER04 instead of a FQDN...
October 26, 2012 at 1:31 pm
After you get MySQL up and running you can also look at using SSMA for MySQL to assist in the migration.
October 26, 2012 at 1:24 pm
A few things to look at:
- How is the new SQL account trying to connect to the database?
- Can you connect the client to the database using SSMS?
-...
October 26, 2012 at 1:05 pm
In-lieu of having TDE available you can use file-level encryption like EFS to encrypt the folders/files where SQL has the data/log/backup files.
As for your access issue in Windows on your...
October 26, 2012 at 12:59 pm
1.can we down grade the sql 2005version ?? from enterprise edition to standard
Nope.
2. can we upgrage workgroup sqlserver 2005 editon to standard edition [which service pack required]
Yep.
October 26, 2012 at 12:51 pm
(1) You say that you're doing this on the Log Ship Destination? Is that right?
I caught that as well. That does not sound right.
As for the transaction logs swelling during...
October 26, 2012 at 12:33 pm
Can you share the setup logs from when you tried to install a new instance of SSRS?
October 26, 2012 at 5:00 am
Oracle has the log miner tool, but that will only work on an Oracle database. Also, it is reading the redo logs, so that would be a transaction that is...
October 24, 2012 at 5:23 pm
I agree that it sounds like a double-hop issue. You can either do what you did, and explicitly define the account that will connect to your data source, or setup...
October 24, 2012 at 2:28 pm
It may be best to setup a profiler trace to include the SQL statement and user errors to see if you can capture what is being passed at the time...
October 24, 2012 at 5:01 am
No, SSIS is not required to run maintenance plans, but maintenance plans actions in SSMS are a subset of what can be done in SSIS and a maintenance plan built...
October 23, 2012 at 10:19 am
Have you checked out the following:
SSIS package does not run when called from a SQL Server Agent job step
October 23, 2012 at 8:24 am
Viewing 15 posts - 586 through 600 (of 966 total)