Disk fragmenation for sql server

Hi There,
Does any one know any good file defragmenation software for sql server 2000
database files? The server needs to be online always and should not affect
database activities? Is it a norm to do file defragmenation for sql 2000
database that have 100 GB of data?
Regards,
Prashanth
Hi Prashanth,
Check out the Space Management features of Quest Central at http://www.quest.com/Quest_Central_f...e_management/.
-Kevin Kline
Quest Software (www.quest.com)
SQL Server MVP
I support PASS, the Professional Association for SQL Server. (www.sqlpass.org)

> Hi There,
> Does any one know any good file defragmenation software for sql server
> 2000
> database files? The server needs to be online always and should not
> affect
> database activities? Is it a norm to do file defragmenation for sql
> 2000
> database that have 100 GB of data?
> Regards,
> Prashanth

Disaster Recovery - How to verify my 2005 standard databases using 2005 express

How to verify the "Full" backups of an online database.

Running MS SQL 2005 on Windows 2003 server using windows domain authentication
Obtaining nightly backups of the application databases & the system databases Installed MS SQL 2005 Express SP2 on a workstationMy task is to take the FULL BAK file(s) and recreate the database on the workstation for Disaster Recovery verification.
What parameters do I need to tweak? Do I need to import the System databases from the server? What security issues must be satisfied to connect on the new machine?

Good questions. I'll answer those below, but I wonder if another method might satisfy what you're really after. If you're looking for a standby system, then use Database Mirroring or Log Shipping or Clustering. All of these will fit the bill.

But on to your specific questions:

First, you can backup a SQL Server 2005 database on any edition and transfer it to another. Certain things work differently in certain editions however, such as replication, database mirroring and so on. You want to ensure that your applications don't depend on those features.

Second, Books Online has several references for moving system databases. Just search for "system databases" and you'll see what you need. It's important to note that you normally don't want to transfer your system databases to another server - the names of the servers and file locations will be different and so on. Backing them up is a good idea, but you don't want to transfer them.

Third, to connect to the second system, you'll need to fix the security in the database.

Buck Woody

|||How does one fix the security problems in the second server?

Is there a formula or a list of parameters to change?|||Do a live.com search on "SQL Server Orphaned Accounts".|||In addition to Bucks comments refer these articles,

www.msdn2.microsoft.com/en-us/library/ms175475.aspx

http://sql-articles.com/articles.php?pageNum_alltop=1&totalRows_alltop=13

http://sql-articles.com/articles.php?pageNum_alltop=0&totalRows_alltop=13

http://deepakinsql.blogspot.com/2007/08/moving-system-databases-in-sql-2005.html

Thanxx
Deepak