Viewing 15 posts - 691 through 705 (of 966 total)
Is the syntax of the command to reinstall master correct? I ask because you listed
"start /wait D:\setup.exe /qn INSTANCENAME=mssqm$ICT REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=StrongPassword"
supplying an instance name of mssqm$ICT yet your error...
September 5, 2010 at 4:31 pm
If the service account that SSIS uses on the machine does not have a login on the named instance or NTFS file permissions to the data/log files of the named...
September 5, 2010 at 4:21 pm
What value are you supplying for @job_login? Is it a valid/active account on the machine/domain the systems are a part of?
September 5, 2010 at 4:17 pm
Yeah, then either log shipping or transactional replication. You can setup transactional replication not to have immediate updates to reduce some of the load on the box. If you have...
September 5, 2010 at 4:12 pm
Sorry. Steve is absolutely correct. I was making an assumption about the full backup restore being done. The logs have to be restored in order, so it will be full,...
September 5, 2010 at 1:42 pm
Also, if it is cross domains you may hit permissions problems even if the everyone group is added if domain trusts are not setup correctly. I would ensure with your...
September 5, 2010 at 1:11 am
You are going to have to get with your storage administrator to work and understand this, as each SAN vendor can implement snapshots in different ways. For example we use...
September 5, 2010 at 1:04 am
You can also try a roundabout way. If the purpose is to not use ADO/SMO yet use the power of powershell you could try something like using sqlcmd inside of...
September 5, 2010 at 12:54 am
Restore from transaction log backups. They should contain all the transactional changes since the last full backup.
September 5, 2010 at 12:44 am
Once you install MSDE, there is no upgrading it to another version like Standard, Enterprise, etc. You can install Enterprise as another instance of SQL on the same machine, but...
September 5, 2010 at 12:38 am
Are any of the queries these users will run going to be expected to modify the data in anyway?
September 4, 2010 at 4:32 pm
If you are moving machines make sure to also plan out carefully where the database files will be. Separation between the OS, data and log files as well as tempdb...
July 9, 2010 at 1:56 pm
Well I would definitely say that your indexes should be rebuilt if any of them have large fragmentation. Does the server have any maintenance periods, non-business hours or known periods...
July 8, 2010 at 2:19 pm
How many VMs are running along with the SQL VM on the same physical box, and what kind of servers are they?
July 7, 2010 at 6:29 pm
The only option left is then to pull the complete data from the production server on a daily basis, which is logically incorrect.
That's not your only option left. Have you...
June 30, 2010 at 1:31 am
Viewing 15 posts - 691 through 705 (of 966 total)