problems clearing cache file C:\inetpub\wwwroot\support_logo_com_tr\cache/refTableSQL/4cb611d25be1157e228580038edc4c74problems clearing cache file C:\inetpub\wwwroot\support_logo_com_tr\cache/refTableSQL/5b0564a25779d05369b38920e8429effproblems clearing cache file C:\inetpub\wwwroot\support_logo_com_tr\cache/refTableSQL/6f278c629e03cd54d6ef6f7fe5767555problems clearing cache file C:\inetpub\wwwroot\support_logo_com_tr\cache/refTableSQL/c124fde494777d86d988e66cc40ee14e Logo Yazılım Destek - Network ve Veritabanı
Error
  • JFTP::delete: Bad response
  • JFTP::delete: Bad response
  • JFTP::delete: Bad response
  • JFTP::delete: Bad response

Network ve Veritabanı

User Rating: / 2
PoorBest 

Syntax :

OSQL -U sa -P -S MakinaAdı

Örnek :
C:\>OSQL -U sa -P passx -S okans
1> BACKUP DATABASE LKSDB TO DISK = 'c:\backupfile.bak'
2> go
Processed 2568 pages for database 'LKSDB', file 'LKSDB_Data' on file 1.
Processed 2 pages for database 'LKSDB', file 'LKSDB_log' on file 1.
BACKUP DATABASE successfully processed 2570 pages in 1.695 seconds (12.416 MB/sec).
1> quit

User Rating: / 3
PoorBest 

This document explains how to change collation name of a database. Before starting,  we need to understand what is Collation.

Collation corresponds to character set in SQL Server. It determines how to use characters in equivalences, order operations, lower and uppercase changes. The "CI" phrase used in  Turkish_CI_AS or SQL_Latin1_General_CP1254_CI_ AS collation that is generally used in Turkish databases means Case Insensitive.

Especially in SQL 2000, Turkish_CI_AS used to be selected as a collation name;  however, SQL_Latin1_General_CP1254_CI_AS is started to be used mostly after upgrading to SQL 2005 and SQL 2008.  

Read more...

User Rating: / 2
PoorBest 

DBCC CHECKDB Veritabanında meydana gelen hataları kontrol etmemizi sağlayan bir prosedürdür ve suspect modunda olduğu gibi herhangi bir veritabanı bozulma durumlarında kullanırız.

DBCC CHECKDB ile parametre olarak verilen database in bütünlük kontrolü yapmaktadır. Bu kontrolde her index’in içeriği validate edilir, metadata ve dosya sistemi arasındaki uyumluluk kontrolü yapılır.

Read more...