Viewing 15 posts - 5,986 through 6,000 (of 9,253 total)
don't move the databases, extract all required objects and import them to your new clustered instance.
February 17, 2012 at 10:04 am
Muralijv 51742 (2/16/2012)
Hi KevinThanks for the update. Do you have suggestions to automate this process.
Thanks in advance.
Cheers
Murali
Not sure what you mean, log shipping is an automated process.
February 16, 2012 at 9:21 am
Declaring an Insensitive cursor should also work
February 16, 2012 at 8:26 am
Starting in SQL server 2008 R2 there is a dynamic management function called sys.dm_os_volume_stats which pulls mount point info per database\database file.
I still prefer WMI though 😉
February 16, 2012 at 5:32 am
Personally i prefer to use WMI to get the volume info, it works for mounted and non mounted volumes so it's completely generic
Roy Moore (2/16/2012)
February 16, 2012 at 4:57 am
If you really must use a cursor then this would be a little more appropriate
declare cursor_db INSENSITIVE cursor for
select sdb.name from sys.databases sdb
where state = 0 and snapshot_isolation_state = 0...
February 15, 2012 at 10:01 am
deva_etc (10/19/2011)
Also in SQL 2005, you have to perform the patch installation from the active node. In SQL 2008, you can patch from any node (rolling upgrade)
Starting 2005 SP2 there...
February 15, 2012 at 9:40 am
LutzM (2/14/2012)
February 15, 2012 at 9:05 am
Muralijv 51742 (2/14/2012)
I will try to restore the logs 4 times a day.Cheers
Murali
In that case log shipping would be perfect
February 15, 2012 at 8:59 am
sqlfriends (2/13/2012)
Thanks, but I got Invalid object name 'sys.dm_server_service'.
What version is your SQL Server instance, the script above is only valid for SQL Server 2008 R2 SP1 onwards. Get your...
February 13, 2012 at 2:54 pm
no, you can do it via SSMS too, on the files tab of the database properties.
February 13, 2012 at 2:43 pm
what edition\version VMWare are you planning?
most of the common ESX licences only allow up to 4 way SMP for VMs.
2vCPUs and 8GB RAM should be enough i would have...
February 13, 2012 at 2:40 pm
sqlfriends (2/13/2012)
When I restore database by using SSMS, I see I can only change physical file name, I don't have a option to change logical name, is that correct?
Correct.
sqlfriends (2/13/2012)
February 13, 2012 at 2:32 pm
all partitions are using either a 1MB offset (Windows 2008 default) or 64K offset.
Only partition 1 on disk 1 has different alignment offset.
Now, can you post your calculations you used...
February 11, 2012 at 10:24 am
Viewing 15 posts - 5,986 through 6,000 (of 9,253 total)