Viewing 15 posts - 31 through 45 (of 58 total)
Are you trying to run the powershell script against the local SQL Server? I know from experience when connecting using WMI (via any method) you cannot supply username/password for the...
July 1, 2013 at 3:44 am
I'd recommend moving the .mdf file back, taking the database offline, move the files, run an alter database statement to move the pointers to the new file location then bring...
June 28, 2013 at 5:54 am
Also, what are the current sizes of the data and log files for that database, and what are the autogrowth options set to for the files?
June 28, 2013 at 5:53 am
As hveermak mentioned, the first thing would be to check whether your SAN storage is using thick or thin provisioning for the volumes, as once you know that you have...
June 27, 2013 at 6:53 am
I'd be tempted to NOT p2v them, but instead build new VMs (and storage) completely fresh (assuming the installs/configuration is documented) and set them up as a brand new cluster...
June 27, 2013 at 4:17 am
Yeah, for all kinds of reasons, I'd never recommend detaching databases/volumes from a LUN from a SAN and just adding it to a cluster, there's so many issues that can...
June 27, 2013 at 2:36 am
What are you actually trying to accomplish here though? The TIMESTAMP data type isn't actually a date/time format, and I believe it's being withdrawn in future versions of SQL Server...
June 27, 2013 at 2:32 am
Yeah, I think it was how the application was parsing the connection string to get the password, as I could connect with the same username/password combo fine in SSMS, but...
June 27, 2013 at 2:15 am
What edition of SQL Server and Windows Server are you using?
June 27, 2013 at 2:13 am
What account is the SQL Server service running as, a domain account or local account? Sounds like it could be an SPN registration issue perhaps if the server and service...
June 27, 2013 at 2:11 am
I've done something similar in the past, having a web application that multiple users were using to update data at the same time. Rather than even thinking about concurrency issues...
June 27, 2013 at 2:08 am
I've experienced this issue if the application is using a SQL login and the @ character is in the password. I could never get the application to connect properly so...
June 26, 2013 at 8:56 am
The calculation is wrong, it should be
(backup_size/1024)/1024
I think
I did it with a quick test of a non compressed, T-SQL only backup here and the value tallied with the...
June 26, 2013 at 6:20 am
Thanks for the clarification. And yes, that last point is critical. Once the cluster comes back online, and available again, I need to understand how long it will likely take...
August 15, 2012 at 3:30 am
Yeah, that's what I was kind of thinking myself. However, if I wanted to use Standard Edition for instance, would that need a license?
May 18, 2012 at 3:15 am
Viewing 15 posts - 31 through 45 (of 58 total)