SQL Server 2008

[Deadstring67]

---

bro onsa on pag manual backu-up sa database? name sa ako database 7hsawater.bak? onsai command back-apan then e restore to other server..

tagaan na lang tika link. pag test sa imo local server. ayaw sa main database ninyo.

How to back up

How to: Back Up a Database (SQL Server Management Studio)
How to: Create a Full Database Backup (Transact-SQL)
How do I quickly back up a database in SQL Server 2005? | TechRepublic

How to restore
How to: Restore a Database Backup (SQL Server Management Studio)
SQL Server 2000 Backup and Restore
Step-By-Step: Learn how to restore databases in Microsoft SQL Server | TechRepublic

Pa member ani bro... blog and forum ni about sql og .net.. naa dghan tutorial diha..
Simple Talk: SQL Server and .Net articles, forums and blogs

[Deadstring67]

SQL Injections

A SQL injection is often used to attack the security of a website by inputting SQL statements in a web form to get a badly designed website to perform operations on the database (often to dump the database content to the attacker) other than the usual operations as intended by the designer. SQL injection is a code injection technique that exploits a security vulnerability in a website's software. The vulnerability happens when user input is either incorrectly filtered for string literal escape characters embedded in SQL statements or user input is not strongly typed and unexpectedly executed. SQL commands are thus injected from the web form into the database of an application (like queries) to change the database content or dump the database information like credit card or passwords to the attacker. SQL injection is mostly known as an attack vector for websites but can be used to attack any type of SQL database.

SQL injection - Wikipedia, the free encyclopedia

[mr.twin]

connect sql 2008 to sharepoint 2010..?

[Deadstring67]

connect sql 2008 to sharepoint 2010..?

E try ni bro..kaso reporting services wala pako ka sulay ani bro. dili ko pahilabton sa ako manager sa amo sharepoint.

Integrating Sharepoint 2010 and SQL Reporting Services 2008
Integrating Sharepoint 2010 and SQL Reporting Services 2008 in 6 easy steps - CodeProject®
How to: Integrate SharePoint 2010 and Reporting Services 2008 R2 - SharePoint By Bugday
Configure a SQL Server Alias for Sharepoint (SQL Server 200 | Ulysses Ludwig's SharePoint blog

[Deadstring67]

How To Convert SQL Server 2008 Database To SQL Server 2005

Requirements
If you are trying to restore database backup of SQL Server 2008 to SQL Server 2005, you are bound to fail. Database backup of SQL Server 2008 is not compatible backward, you cannot restore it to SQL Server 2005. The following is a solution to convert databases of SQL Server 2008 to 2005

Step by Step Guide
1) Start convert wizard

Open SQL Server Management Studio2008. in 'Object Explorer', right click the database that you want to convert. Select 'Tasks' > 'Generate Scripts...'.


2) Next

Click 'Next'.


3) Select database and objects

Select the database that you want to convert, and check on 'Scripts all objects in the selected databases'


4) Convert Options

Set options:

'Script for Server Version' = 'SQL Server 2005'
'Script Data' = 'True'
'Scirpt Database Create' = 'True'
[img][/img]

5) Output Option

Select option 'Script to file', 'Single file' and 'Unicode text'.


6) 'Finish'

View summary and click 'Finish'.


7) Result

Now you got a complete database creation script with data. It can be executed on target database server.

Amend Script

Open the generated script in SQL Server Management Studio 2005. Find the following section and amend the path to proper data folder

CREATE DATABASE [StockTraderDB] ON PRIMARY
( NAME = N'StockTraderDB',
FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\StockTraderDB .mdf ,
SIZE = 4352KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'StockTraderDB_log',
FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\StockTraderDB _log.LDF',
SIZE = 6272KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)

9) Execute the Script

When finished, You should get converted database of SQL Server 2005

Source: How To Convert SQL Server 2008 Database To SQL Server 2005?

[nailv]

..................................

[Deadstring67]

..................................

unsa man dodong alvin?

[wire]

...this very comprehensive bro. nice nice thanks!

How To Convert SQL Server 2008 Database To SQL Server 2005

Requirements
If you are trying to restore database backup of SQL Server 2008 to SQL Server 2005, you are bound to fail. Database backup of SQL Server 2008 is not compatible backward, you cannot restore it to SQL Server 2005. The following is a solution to convert databases of SQL Server 2008 to 2005

Step by Step Guide
1) Start convert wizard

Open SQL Server Management Studio2008. in 'Object Explorer', right click the database that you want to convert. Select 'Tasks' > 'Generate Scripts...'.


2) Next

Click 'Next'.


3) Select database and objects

Select the database that you want to convert, and check on 'Scripts all objects in the selected databases'


4) Convert Options

Set options:




5) Output Option

Select option 'Script to file', 'Single file' and 'Unicode text'.


6) 'Finish'

View summary and click 'Finish'.


7) Result

Now you got a complete database creation script with data. It can be executed on target database server.

Amend Script

Open the generated script in SQL Server Management Studio 2005. Find the following section and amend the path to proper data folder


9) Execute the Script

When finished, You should get converted database of SQL Server 2005

Source: How To Convert SQL Server 2008 Database To SQL Server 2005?

[Deadstring67]

...this very comprehensive bro. nice nice thanks!

thanks bro..

di man gud kaau lisod if sql 2005 e upgrade nimo to 2008..
ang 2008 to 2005 baling labara sa ulo..
E make sure dili nimo e apil ang data inig himo sa script..pilia ra ang Schema. grabeng bug ata nya mag error.

[nailv]

ngano ni purchase man ug SQL 2008 nga e downgrade ra man diay sa 2005? Mora nag Windows 2008 e downgrade sa 2003... hehe

DBA diay ka camz.. dli ka system engr. hehe