Hi Salah,

The database restore (miror) must use the NO RECOVERY option, so the database stays in a loading state (principle of miroring no!).

If you want to move the database...

Hi,

I am not sure you could make mirroring between SQL Server 2005 (As principal) and SQL Server 2000 (As miror).

...

Hi,

You will find all details in the following links:

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1199004,00.html

http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

Regards,

Ahmed

In SSMS you right click on the system stored proc and choose modify. that's it.

Hi california,

Check this may it helps : http://msdn2.microsoft.com/en-us/library/ms186385.aspx

http://www.mssqltips.com/tip.asp?tip=1234

http://www.sqlservercentral.com/Forums/Topic396310-405-1.aspx

Regards,

Ahmed

Salam,

I am not sure your are talking about 2005 (see the subject post) or 2000 (see the body post).

Check the following links http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=168796&SiteID=1

http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx

http://sqljunkies.com/HowTo/2E1101E0-D5C1-4DBD-A398-FE485DFA439B.scuk

Regards,

Ahmed

Hi,

I think you have to write a script to check the following:

1- System configuration (OS)

2- SQL Server general details

3- Databases status and configurations

4- Space usage

5- Input /Output per Database (or...

Hi,

It's a MS bug, the same problem is with views, but in the views you have just to use WITH SCHEMABINDING.

For functions I think you have to alter the two...

Hi,

I want to share the info, there is new tool in SQL Server 2005 Called tablediff.exe located in "\Program Files\Microsoft SQL Server\90\COM\tablediff.exe".

Check the following link for more info http://msdn2.microsoft.com/en-us/library/ms162843.aspx

There...

Hi,

Check the following links:

http://www.pinaldave.com/download/sqlinterview.pdf

http://www.techinterviews.com/?p=131

http://www.sqlservercentral.com/Forums/Topic290540-164-2.aspx#bm414349

http://www.geekinterview.com/Interview-Questions/Database/SQL-server-2000-interview-questions

http://vyaskn.tripod.com/iq.htm

http://www.t-mug.org/Interview_SQL.aspx

http://sqljunkies.com/WebLog/joshcrosby/archive/2004/10/23/4754.aspx

http://www.geekinterview.com/talk/105-sql-quiz-package-100-questions-free.html

Regards,

Ahmed

Hi Minaz,

Yes I understood I just want share information I have

Thanks

Hi,

Restore the full backup , then all transaction logs and that's it

Check the following links

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx

Backing Up and Restoring SQL Server Databases and Transaction Logs

http://www.databasejournal.com/features/mssql/article.php/2232371

http://www.builderau.com.au/program/sqlserver/soa/Restore-your-SQL-Server-database-using-transaction-logs/0,339028455,339282046,00.htm

Regards,

Ahmed

Hi,

You cannot use it with SQL Server 2000 standard edition and Windows 2003 standard edition.

Check the following links:

How to configure SQL Server to use more than 2 GB of physical...

Hi,

Check what is your Dump directory in the 'SQL Server Configuration Manager'

http://msdn2.microsoft.com/en-us/library/ms345416.aspx

Go to this directory to check the trace (the directory is something like D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG)

Regards

Hi,

Yes it is.

Look at the following link

http://technet.microsoft.com/en-us/library/bb663704.aspx

Regards,

Ahmed