use import\export wizard ,give source as excel,destinati on as database name.
good luck.
bharadwaj
Last Activity: Aug 7 '07, 10:28 AM
Joined: Jun 18 '07
Location:
-
restore the dts
Hi,
By mistake i have deleted the dts package. how can i restore that.
any advice pls.........
regards
bharat -
Hi,
Thanks 4 ur response.
I have taken the backups from production and copy to other server ,then I will execute this restoration automated script for all the databases.
My script is given below.
----
-----
set @logical_data_n ame =@db_name + '_' + 'data'
set @logial_log_nam e =@db_name + '_' + 'log'
---
---
RESTORE DATABASE @db_name
...Leave a comment:
-
rename of logical file name
Hi,
If I will rename the logical file name in production will it create any issues.(sql server 2000).
I am getting the problem while restore the production database to other server. So,that I am planning to rename the logical name. The restoration is automated job for all the databases. That restoration script is working fine execpt for 3 databases because the logical names are different for these databases
Any advice.... -
This will help you. first declare the parameters and use the following code.
set @backup_filePar tialname = @diff_backup_pa th+@db_name + '_*.bak'
set @backup_filenam e = @db_name + '.bak'
set @dos_cmd = 'RENAME ' + @backup_filePar tialname + ' ' + @backup_filenam e
EXEC @dos_result = master.dbo.xp_c mdshell @dos_cmd, NO_OUTPUTLeave a comment:
-
Master Database Restoration
hi,
i am trying to do master restoration using the following steps.
1.net stop MSSQLServer
2.sqlservr -m
3.use MASTER
go
RESTORE DATABASE master FROM disk='master.BA K'
replace,
MOVE 'master' to 'E:\Program Files\Microsoft SQL Server\Data\mas ter.mdf',
MOVE 'mastlog' to 'E:\Program Files\Microsoft SQL Server\\Data\ma stlog.ldf'
when i execute the step 3 i am getting the below... -
i dont no abt Csharp.
but i found the following code in google.hope this will help u.in this code i have commented the code contains how check the connectivity
[code=cpp]
using System;
using System.Data.Sql Client;
using System.Data.Sql Types;
using SeminarsInfo.Da taAccessor;
using SeminarsInfo.Ut il;
namespace SeminarsInfo.Tr ansformer
{
/// <summary>
...Leave a comment:
-
open enterprise manager,in that goto-->>
console root-->sql server group-->instance name(urs database instance).
let me know can u able to open instanceLeave a comment:
-
Access is denied will come for the following situations.
1.Due to network failure.
2. Bcos of authentication and the password while registering the instance of sql server.
3.Add the instance in client network utility.
hope this will help u.Leave a comment:
-
renaming of subfolders
Hi,
We are taking backups for different databases in the same folder with date and time.I am copying those backups to other server,in that
I want to rename those backups without date and time format for other purpose.
can i get any syntax using xp_cmd_shell.
Pls find the following code and give me your advice.
declare @currentFolderP ath varchar(256)
declare @command varchar(1000)
declare... -
try this
BACKUP DATABASE abc
TO DISK='C:\backup s\abc.bak'
WITH FORMAT
GO...Leave a comment:
-
restoration automation
Hi,
I am trying to do restoration for n databases using automated script.The script is given below. it is not giving errors while job execution ,but restoration is not happening.(no record is in msdb.restorehis tory).
any advice from you. I have doubt on my dynamic sql part.
CREATE procedure test_restore
as
DECLARE @backup_set_id_ Full INT
--DECLARE @Full_Backup_Se t_Date datetime ... -
hi,
run the following commands.
1.dbcc sqlperf(logspac e) . in the out put u can get the log size.
2.backup log <dbname> with truncate_only
3.dbcc shrinkdatabase( dbname,10)
4.dbcc shrinkfile(2) (2 means log file)
after these steps over execute step 1 again after 10 or 20 mins ,let me know the log size growth.
good luck
BharatLeave a comment:
-
how to stop the query
Hi All,
I am executing one query in sql analyzer. It was taking too much of time.I am not able to stop the query using stop button,it was not responding.
Many users are working with that database at the same time,not possible to stop services(agent or server) also.
Any help from you.
Regards
Bharat -
boss try this
CREATE PROCEDURE PAGE_COUNT
@BNAME NVARCHAR(50)
as
BEGIN
----QUERY FOR THE TOTAL COUNT WITHOUT SEPARATOR
DECLARE @PAGECOUNT INT
SET @PAGECOUNT = ( select COUNT(IMGTABLE. BATCHID) FROM IMGTABLE WHERE (BATCHID = 1))
----QUERY FOR THE SEPARATOR COUNT
DECLARE @SEPARATORCOUNT INT
SET @SEPARATORCOUNT =( select COUNT(BARCODETA BLE.BATCHID) FROM BARCODETABLE WHERE (BATCHID...Leave a comment:
-
hi,
if the no of records are greater than 67000 in excel,it is not possible to copy to sql server.you need to split that excel into different files.
if you can copy that excel to MSaccess you can send large data to sql server
through dts only.Leave a comment:
-
Hi sashi,
we r usinq sql2000. logshipping is going on.we have remove the logshipping recently.that time we have done some mistake.now when we try to re-configure logshipping,we found that the database is there in secondary server (with loading state).
I have checked the following things.
1.attach\detach database.
2.take offline for that database
3. restore database with recovery.
4.sp_dbremove...Leave a comment:
-
delete the databse
how can i delete the database if it is in loading state???
any help -
Thanks for ur reply.I will try it and let you know.
Bharat...Leave a comment:
-
automatic restoration
any automated restoration script is available in sql server2000.
I want to do the restoration for 10 databases(full backup,latest differential backup) in other server.
Pls do the needful.
No activity results to display
Leave a comment: