Can you please conform that table partitioning/Index partitioning is allowed or not in SQL Server2005/SQL Server 2008 Standared edition.
Below is the exc that needs to be run to have the backward complatabilty.
Adding to my presvious help i have sql server 2005 developer edtion with out any service pach.
No Still struglling, actaully I am installing SQL Server 2005 EE with backwards compatability so that I can restore this SQL Server2000 backup on...
I mean Database migration i.e side by side or upgrade.
Thanks for your reply.
Can we restore Database backup from Developer Edition of SQL Server 2005 to Enterprise Edition of SQL Server 2005.
Can you responed me ASAP....
I got the answer for my question below is the Syntax to verify the backup which is having multipule files.
RESTORE VERIFYONLY FROM...
THank for you help but i am not able use the syntax as it is use full for only 1 file verification.
It is SQL Server 2000, trying to restore it to the original server i don't have any backup of this databases
I have a backup file(Full backup) which is Corrupted can you please recommand me how to recover the data from it. Few details are as below....
I am using SQL Server 2000 I am taking the backup of a Database in 3 file in local hard disk. Can you please let me know how to verify the...
Let thank for your reply, i found what was the reason for the failure? The service account for which I have installed doesn't have local...
I want to move tempdb physical files to different drive. I used the below code to move the file after running i got saying that the file are...
I have Q? if you have 2 node cluster and 2 node instance it is and each node is hosting one SQ LServer now how do you find that which one...
I have done MCDBA(SQl Server2000)I am planing to do on SQL server2005 as well can any one can help me what are all the papers I need to for...
HI,<br /><br />Sorry for the late reply, this has helped me a lot.<br /><br />you help is very much appricate <img...
thanks for your reply but i want to alter a cloum in a table which is already in replication i don't want to stop the replication....
I need to alter a column in a Article(table) which is in Transacational replicationa.
Can you please let me know how i can do the same.
Thanks this is what i am looking for.
Separate names with a comma.