Viewing 15 posts - 1 through 15 (of 150 total)
I usually accomplish this with DNS names that are not the hostnames of the SQL Servers. You probably will not be able to set that up for the move...
August 25, 2014 at 2:13 pm
Could this be a User Access Control problem, then? Windows is starting to move away from allowing people to write files tot he root of drives.
August 22, 2014 at 6:47 am
This is the sort of thing that makes me put "Access Denied" at the very top of my most hated error messages list. Just once, I would love to...
August 21, 2014 at 8:25 am
The only thing I can think of is that it may not actually be a SQL 2012 instance. Even eval edition instances should show up. Could this really...
August 21, 2014 at 7:38 am
I am not sure, but I think I smell a normalization problem here. From the data you have given, it looks like the ID field is interpreted as a...
August 21, 2014 at 7:33 am
Since the T-SQL backup succeeded, that implies that the SQL Server service account has appropriate permissions. Could the GUI be using the user's credentials to confirm the existence of...
August 21, 2014 at 7:29 am
I have to deal with a vendor who has the following advice in their Tuning and Scaling guide:
Setting Recovery Model to Simple has the lowest amount of overhead over Full...
July 31, 2014 at 12:32 pm
Is this cluster running with Always On? In that case, you would need to create all of the logins on both instances of SQL Server.
July 29, 2014 at 12:52 pm
To be fair, it will only tell you some of the contents of the file, and will not update anything. I am just curious to see if a) ...
July 25, 2014 at 9:12 am
Can you do a restoreheaderonly from the backup file?
July 25, 2014 at 8:46 am
Check to see if the snapshot job has run. If you right click on the replication in Management Studio, you should see an option for View Snapshot Agent Status.
July 24, 2014 at 7:09 am
Change the execute as principal from the domain user to dbo.
Alternatively, you can grant the alter any role permission in the database, and he can add users to any role...
July 23, 2014 at 11:41 am
The errors are largely from SQL Agent. They are saying you can not start a job that is currently running. It is nothing to worry over.
July 23, 2014 at 11:37 am
You may very well be signing up for a lot of work (and troubleshooting afterward) that may not be necessary. What is reason for the change in the collation?...
July 23, 2014 at 11:33 am
On the guess that you mean you want all of the files to be the same size, or the same usage, this may go one of two ways. Are...
July 21, 2014 at 12:27 pm