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.
Joie Andrew
"Since 1982"
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.
Installation Guide - Quest Software
Joie Andrew
"Since 1982"
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,...
Joie Andrew
"Since 1982"
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...
Joie Andrew
"Since 1982"
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.
Joie Andrew
"Since 1982"
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?
-...
Joie Andrew
"Since 1982"
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...
Joie Andrew
"Since 1982"
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.
Joie Andrew
"Since 1982"
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...
Joie Andrew
"Since 1982"
October 26, 2012 at 12:33 pm
Can you share the setup logs from when you tried to install a new instance of SSRS?
Joie Andrew
"Since 1982"
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...
Joie Andrew
"Since 1982"
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...
Joie Andrew
"Since 1982"
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...
Joie Andrew
"Since 1982"
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...
Joie Andrew
"Since 1982"
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
Joie Andrew
"Since 1982"
October 23, 2012 at 8:24 am
Viewing 15 posts - 586 through 600 (of 966 total)