Viewing 15 posts - 61 through 75 (of 77 total)
No, things don't get any easier if the database is SQL 2005 instead of SQL 2008.
As you have SAN storage, work with your SAN Admins and see what snapshot features...
August 2, 2009 at 5:58 pm
If you have a SAN, and you have the required software to handle it (some vendors charge an extra fee to do this automatically, or you can usually do it...
July 31, 2009 at 9:34 pm
Using SQL Server 2000 as the source you pretty much only have one option, Log shipping. Using replication under SQL 2000 will add a column to all the tables...
July 31, 2009 at 4:22 pm
Yes you will need to sync the logins to users. You have to do this if the service is stopped or if the database is detached.
July 21, 2009 at 4:13 pm
Nope, and there's no need to. Simply copy the mdf and ldf files to the other server and attach them.
Done.
July 16, 2009 at 6:48 pm
There will be a couple of features which are different, such as online index rebuilds won't work any more, and some of the really high end table partitioning features. ...
June 30, 2009 at 12:34 pm
Syngress has a study guide out called "The Real MCTS SQL Server 2008 Exam 70-432 Database Implementation and Maintenance Prep Kit". The ISBN for the book is 978-1-59749-420-5.
Granted I'm...
June 22, 2009 at 10:24 pm
Do an purchase the developer edition of SQL Server. It's $50 US, you can use it for anything as long as it isn't a production server.
May 4, 2009 at 2:45 am
No this isn't possible. Each instance requires its own disks on the cluster.
Another issue you'll find is that I don't believe that you can install SQL 2000 and SQL...
April 23, 2009 at 10:44 am
isaacsonj (3/31/2009)
"SQL Server 2000 Meta Data Services packages are not supported"
and
"SQL Server 2000 DTS Designer components are required to edit DTS packages"
I get...
March 31, 2009 at 12:19 pm
isaacsonj (3/31/2009)
I think this is...
March 31, 2009 at 12:17 pm
You basically have two options.
The first is merge replication as this allows you to update either system and feed the changes back to the publisher.
The second is that in the...
March 31, 2009 at 11:13 am
According to this Microsoft Page upgrades to the Eval Edition are not supported.
March 30, 2009 at 12:55 pm
Browse to the folder location in Windows Explorer and edit the NTFS permissions to give the SQL Service rights to the folder.
February 8, 2009 at 2:49 pm
By default the SQL Server account won't have access to the folders that the replication needs to use if the SQL Server is running under a local or domain account...
February 6, 2009 at 10:06 pm
Viewing 15 posts - 61 through 75 (of 77 total)