Check whether the log file size is limited to any particular value for that DB.

If accessible take a Log backup of that database and shrink the log file.

If you still...

They are connect but no executing anything

The snapshot will contain the initial data ie the data when you took the snapshot...Using snapshot you can restore that point

Hi Ajay,

Please try taking backup by checking the verify backup option in GUI.

Also please verify you are giving the right path to take the backup

Hi,

Please select VERIFY option when you take backup using GUI.

Since you dont face any problems in restoring a backup taken using TSQL hope u r DB is perfect..

If u can...

Just check the backup file using RESTORE VERIFYONLY FROM DISK = 'path of backup file'

Use this

alter schema schema1 transfer schema2.table_name

Try this...

USE MASTER

GO

SET NOCOUNT ON -- Turn off Rows Affected Message in output script

SELECT -- Create Windows Logins

CHAR(13) + CHAR(10) + '-- ADD WINDOWS LOGIN '...

Thanks All,

😀

U mean the issue is due to SQL server?

Shrink the db having high log file size.

Check the temp DB, if its huge and ur server is not production then restart...

Search google for 'litespeed'.. its a third party software

tony (4/28/2009)

---

Hi,

I have a data table that has multiple columns that have similar data, e.g. skills of a worker.

There are 8 columns and there is no prefined order in which...

Are you sure you have installed server on you machine?

If yes then trying connecting giving .(dot) as server name.

If ur using sqlexpress try ./sqlexpress

Eswin (4/28/2009)

---

Hi experts,

As part of the requirement for a proposal on Data Warehousing, I am in need of the following items.

1. Design implementation procedures to maintain DBMS environment

2. Documentation...

Are you still facing the problem?

Whats the service pack you are using?